{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# pandas加载数据"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 加载Text文件"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>name</th>\n",
       "      <th>age</th>\n",
       "      <th>height</th>\n",
       "      <th>class</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>张三</td>\n",
       "      <td>23</td>\n",
       "      <td>1.75</td>\n",
       "      <td>python</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>李四</td>\n",
       "      <td>24</td>\n",
       "      <td>1.72</td>\n",
       "      <td>java</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>王五</td>\n",
       "      <td>35</td>\n",
       "      <td>1.78</td>\n",
       "      <td>php</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>赵六</td>\n",
       "      <td>16</td>\n",
       "      <td>1.83</td>\n",
       "      <td>C++</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   id name  age  height   class\n",
       "0   1   张三   23    1.75  python\n",
       "1   2   李四   24    1.72    java\n",
       "2   3   王五   35    1.78     php\n",
       "3   4   赵六   16    1.83     C++"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "pd.read_table('data/01.txt')    #默认用Tab分隔符"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>python</td>\n",
       "      <td>30</td>\n",
       "      <td>100</td>\n",
       "      <td>300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>java</td>\n",
       "      <td>100</td>\n",
       "      <td>300</td>\n",
       "      <td>1000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>php</td>\n",
       "      <td>50</td>\n",
       "      <td>200</td>\n",
       "      <td>500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>C++</td>\n",
       "      <td>100</td>\n",
       "      <td>100</td>\n",
       "      <td>1000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   0       1    2    3     4\n",
       "0  1  python   30  100   300\n",
       "1  2    java  100  300  1000\n",
       "2  3     php   50  200   500\n",
       "3  4     C++  100  100  1000"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.read_table('data/02.txt', sep = '|', header = None)    #指定'\\'分隔符，无标题行"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Course</th>\n",
       "      <th>Hours</th>\n",
       "      <th>Students</th>\n",
       "      <th>Price</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>python</td>\n",
       "      <td>30</td>\n",
       "      <td>100</td>\n",
       "      <td>300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>java</td>\n",
       "      <td>100</td>\n",
       "      <td>300</td>\n",
       "      <td>1000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>php</td>\n",
       "      <td>50</td>\n",
       "      <td>200</td>\n",
       "      <td>500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>C++</td>\n",
       "      <td>100</td>\n",
       "      <td>100</td>\n",
       "      <td>1000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Course  Hours  Students  Price\n",
       "1  python     30       100    300\n",
       "2    java    100       300   1000\n",
       "3     php     50       200    500\n",
       "4     C++    100       100   1000"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.read_table('data/02.txt', sep = '|', names = ['Course', 'Hours', 'Students', 'Price'])    #指定'\\'分隔符，指定列名"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 加载Csv文件"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>name</th>\n",
       "      <th>age</th>\n",
       "      <th>height</th>\n",
       "      <th>class</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>张三</td>\n",
       "      <td>23</td>\n",
       "      <td>1.75</td>\n",
       "      <td>python</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>李四</td>\n",
       "      <td>24</td>\n",
       "      <td>1.72</td>\n",
       "      <td>java</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>王五</td>\n",
       "      <td>35</td>\n",
       "      <td>1.78</td>\n",
       "      <td>php</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>赵六</td>\n",
       "      <td>16</td>\n",
       "      <td>1.83</td>\n",
       "      <td>C++</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   id name  age  height   class\n",
       "0   1   张三   23    1.75  python\n",
       "1   2   李四   24    1.72    java\n",
       "2   3   王五   35    1.78     php\n",
       "3   4   赵六   16    1.83     C++"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.read_csv('data/03.csv')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 加载Excel文件"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>姓名</th>\n",
       "      <th>课程</th>\n",
       "      <th>分数</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>张三</td>\n",
       "      <td>python</td>\n",
       "      <td>95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>李四</td>\n",
       "      <td>java</td>\n",
       "      <td>98</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>王五</td>\n",
       "      <td>php</td>\n",
       "      <td>100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>赵六</td>\n",
       "      <td>C++</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   姓名      课程   分数\n",
       "0  张三  python   95\n",
       "1  李四    java   98\n",
       "2  王五     php  100\n",
       "3  赵六     C++   90"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.read_excel('data/04.xlsx')    #pip instal xlrd"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 加载Html文件"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "tables = pd.read_html('data/05.html', header=0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(tables)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>学号</th>\n",
       "      <th>姓名</th>\n",
       "      <th>年龄</th>\n",
       "      <th>班级</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1001</td>\n",
       "      <td>张三</td>\n",
       "      <td>22</td>\n",
       "      <td>python04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1002</td>\n",
       "      <td>李四</td>\n",
       "      <td>22</td>\n",
       "      <td>java04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1003</td>\n",
       "      <td>王五</td>\n",
       "      <td>22</td>\n",
       "      <td>php04</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     学号  姓名  年龄        班级\n",
       "0  1001  张三  22  python04\n",
       "1  1002  李四  22    java04\n",
       "2  1003  王五  22     php04"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tables[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>班级</th>\n",
       "      <th>课程</th>\n",
       "      <th>课时</th>\n",
       "      <th>学生人数</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>python04</td>\n",
       "      <td>python</td>\n",
       "      <td>30</td>\n",
       "      <td>100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>java04</td>\n",
       "      <td>java</td>\n",
       "      <td>100</td>\n",
       "      <td>300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>php04</td>\n",
       "      <td>php</td>\n",
       "      <td>50</td>\n",
       "      <td>200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>C++04</td>\n",
       "      <td>C++</td>\n",
       "      <td>100</td>\n",
       "      <td>100</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         班级      课程   课时  学生人数\n",
       "0  python04  python   30   100\n",
       "1    java04    java  100   300\n",
       "2     php04     php   50   200\n",
       "3     C++04     C++  100   100"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tables[1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>学号</th>\n",
       "      <th>姓名</th>\n",
       "      <th>年龄</th>\n",
       "      <th>班级</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1001</td>\n",
       "      <td>张三</td>\n",
       "      <td>22</td>\n",
       "      <td>python04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1002</td>\n",
       "      <td>李四</td>\n",
       "      <td>22</td>\n",
       "      <td>java04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1003</td>\n",
       "      <td>王五</td>\n",
       "      <td>22</td>\n",
       "      <td>php04</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     学号  姓名  年龄        班级\n",
       "0  1001  张三  22  python04\n",
       "1  1002  李四  22    java04\n",
       "2  1003  王五  22     php04"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tables = pd.read_html('data/05.html', header=0, attrs={'class':'students'})\n",
    "tables[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>班级</th>\n",
       "      <th>课程</th>\n",
       "      <th>课时</th>\n",
       "      <th>学生人数</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>python04</td>\n",
       "      <td>python</td>\n",
       "      <td>30</td>\n",
       "      <td>100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>java04</td>\n",
       "      <td>java</td>\n",
       "      <td>100</td>\n",
       "      <td>300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>php04</td>\n",
       "      <td>php</td>\n",
       "      <td>50</td>\n",
       "      <td>200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>C++04</td>\n",
       "      <td>C++</td>\n",
       "      <td>100</td>\n",
       "      <td>100</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         班级      课程   课时  学生人数\n",
       "0  python04  python   30   100\n",
       "1    java04    java  100   300\n",
       "2     php04     php   50   200\n",
       "3     C++04     C++  100   100"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tables = pd.read_html('data/05.html', header=0, attrs={'class':'classes'})\n",
    "tables[0]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 加载MySQL数据"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>title</th>\n",
       "      <th>url</th>\n",
       "      <th>pic</th>\n",
       "      <th>teacher</th>\n",
       "      <th>time</th>\n",
       "      <th>price</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>116</td>\n",
       "      <td>FFMpeg视频开发与应用基础——使用F...</td>\n",
       "      <td>https://edu.csdn.net/course/detail/2515</td>\n",
       "      <td>https://img-bss.csdn.net/201606131053129326.jpg</td>\n",
       "      <td>殷汶杰</td>\n",
       "      <td>21</td>\n",
       "      <td>50.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>117</td>\n",
       "      <td>Java8零基础入门</td>\n",
       "      <td>https://edu.csdn.net/course/detail/3044</td>\n",
       "      <td>https://img-bss.csdn.net/201805100755115951.jpg</td>\n",
       "      <td>肖海鹏</td>\n",
       "      <td>40</td>\n",
       "      <td>1.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>118</td>\n",
       "      <td>项目实战：大型分布式连锁酒店系统</td>\n",
       "      <td>https://edu.csdn.net/course/detail/3935</td>\n",
       "      <td>https://img-bss.csdn.net/201706011726012883.png</td>\n",
       "      <td>肖海鹏</td>\n",
       "      <td>54</td>\n",
       "      <td>577.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>119</td>\n",
       "      <td>C语言大型软件设计的面向对象</td>\n",
       "      <td>https://edu.csdn.net/course/detail/6496</td>\n",
       "      <td>https://img-bss.csdn.net/201711171518014819.png</td>\n",
       "      <td>宋宝华</td>\n",
       "      <td>1</td>\n",
       "      <td>65.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>120</td>\n",
       "      <td>Spring Cloud 微服务实战</td>\n",
       "      <td>https://edu.csdn.net/course/detail/5840</td>\n",
       "      <td>https://img-bss.csdn.net/201709051544372665.jpg</td>\n",
       "      <td>王浩彬</td>\n",
       "      <td>18</td>\n",
       "      <td>268.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>121</td>\n",
       "      <td>Python基础快速入门</td>\n",
       "      <td>https://edu.csdn.net/course/detail/5814</td>\n",
       "      <td>https://img-bss.csdn.net/201708311438433250.jpg</td>\n",
       "      <td>黄勇</td>\n",
       "      <td>117</td>\n",
       "      <td>129.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>122</td>\n",
       "      <td>深度解剖dubbo源码</td>\n",
       "      <td>https://edu.csdn.net/course/detail/5475</td>\n",
       "      <td>https://img-bss.csdn.net/201801290929025603.jpg</td>\n",
       "      <td>卢铄波(阿甘）</td>\n",
       "      <td>30</td>\n",
       "      <td>469.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>123</td>\n",
       "      <td>Python机器学习经典案例实战</td>\n",
       "      <td>https://edu.csdn.net/course/detail/4531</td>\n",
       "      <td>https://img-bss.csdn.net/201703240854465699.jpg</td>\n",
       "      <td>韦玮</td>\n",
       "      <td>5</td>\n",
       "      <td>299.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>124</td>\n",
       "      <td>Python数据分析与挖掘经典案例实战</td>\n",
       "      <td>https://edu.csdn.net/course/detail/3569</td>\n",
       "      <td>https://img-bss.csdn.net/201612301543471953.jpg</td>\n",
       "      <td>韦玮</td>\n",
       "      <td>36</td>\n",
       "      <td>199.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>125</td>\n",
       "      <td>MATLAB基础知识大串讲</td>\n",
       "      <td>https://edu.csdn.net/course/detail/3527</td>\n",
       "      <td>https://img-bss.csdn.net/201612271504381160.png</td>\n",
       "      <td>魏伟</td>\n",
       "      <td>60</td>\n",
       "      <td>30.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>126</td>\n",
       "      <td>Lua语言从入门到精通</td>\n",
       "      <td>https://edu.csdn.net/course/detail/2994</td>\n",
       "      <td>https://img-bss.csdn.net/201609201310378738.png</td>\n",
       "      <td>杨振</td>\n",
       "      <td>66</td>\n",
       "      <td>15.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>127</td>\n",
       "      <td>华为工程师，带你实战C++</td>\n",
       "      <td>https://edu.csdn.net/course/detail/2322</td>\n",
       "      <td>https://img-bss.csdn.net/201605061231337444.jpg</td>\n",
       "      <td>王桂林</td>\n",
       "      <td>81</td>\n",
       "      <td>25.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>128</td>\n",
       "      <td>JFinal极速开发企业实战</td>\n",
       "      <td>https://edu.csdn.net/course/detail/1968</td>\n",
       "      <td>https://img-bss.csdn.net/201601220918102784.jpg</td>\n",
       "      <td>牟孟孟（小木）</td>\n",
       "      <td>100</td>\n",
       "      <td>260.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>129</td>\n",
       "      <td>C语言及程序设计进阶</td>\n",
       "      <td>https://edu.csdn.net/course/detail/504</td>\n",
       "      <td>https://img-bss.csdn.net/201503141137247000.png</td>\n",
       "      <td>贺利坚</td>\n",
       "      <td>43</td>\n",
       "      <td>30.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>130</td>\n",
       "      <td>C++语言基础</td>\n",
       "      <td>https://edu.csdn.net/course/detail/474</td>\n",
       "      <td>https://img-bss.csdn.net/201503010255312402.png</td>\n",
       "      <td>贺利坚</td>\n",
       "      <td>87</td>\n",
       "      <td>75.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>131</td>\n",
       "      <td>Spring MVC视频</td>\n",
       "      <td>https://edu.csdn.net/course/detail/408</td>\n",
       "      <td>https://img-bss.csdn.net/201502100255203210.jpg</td>\n",
       "      <td>佟刚</td>\n",
       "      <td>60</td>\n",
       "      <td>25.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>132</td>\n",
       "      <td>使用swing、三层架构实现学生管理系统</td>\n",
       "      <td>https://edu.csdn.net/course/detail/5573</td>\n",
       "      <td>https://img-bss.csdn.net/201708121505163007.png</td>\n",
       "      <td>马亚军</td>\n",
       "      <td>25</td>\n",
       "      <td>299.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>133</td>\n",
       "      <td>分布式动态数据源切换攻略</td>\n",
       "      <td>https://edu.csdn.net/course/detail/6291</td>\n",
       "      <td>https://img-bss.csdn.net/201803191642534078.png</td>\n",
       "      <td>Array老师</td>\n",
       "      <td>23</td>\n",
       "      <td>109.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>134</td>\n",
       "      <td>大型Java项目视频教程_王勇老师DRP...</td>\n",
       "      <td>https://edu.csdn.net/course/detail/6608</td>\n",
       "      <td>https://img-bss.csdn.net/201712052038189430.jpg</td>\n",
       "      <td>王勇</td>\n",
       "      <td>292</td>\n",
       "      <td>299.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>135</td>\n",
       "      <td>基于Maven+ SpringMVC+ MyBatis ...</td>\n",
       "      <td>https://edu.csdn.net/course/detail/6936</td>\n",
       "      <td>https://img-bss.csdn.net/201801161228103095.jpg</td>\n",
       "      <td>易拙言</td>\n",
       "      <td>43</td>\n",
       "      <td>99.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>136</td>\n",
       "      <td>零基础学会在Linux上编译调试C++项目</td>\n",
       "      <td>https://edu.csdn.net/course/detail/3738</td>\n",
       "      <td>https://img-bss.csdn.net/201701111403485497.png</td>\n",
       "      <td>夏曹俊</td>\n",
       "      <td>32</td>\n",
       "      <td>48.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>137</td>\n",
       "      <td>计算机科学与编程导论</td>\n",
       "      <td>https://edu.csdn.net/course/detail/3523</td>\n",
       "      <td>https://img-bss.csdn.net/201612262224358345.jpg</td>\n",
       "      <td>杨波</td>\n",
       "      <td>14</td>\n",
       "      <td>98.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>138</td>\n",
       "      <td>VC++Windows多线程实战图片编辑器</td>\n",
       "      <td>https://edu.csdn.net/course/detail/3685</td>\n",
       "      <td>https://img-bss.csdn.net/201701051654056277.png</td>\n",
       "      <td>夏曹俊</td>\n",
       "      <td>23</td>\n",
       "      <td>89.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>139</td>\n",
       "      <td>深入浅出C语言（配套完整习题 + 源代码）</td>\n",
       "      <td>https://edu.csdn.net/course/detail/4571</td>\n",
       "      <td>https://img-bss.csdn.net/201703291640393490.jpeg</td>\n",
       "      <td>林世霖</td>\n",
       "      <td>31</td>\n",
       "      <td>69.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>140</td>\n",
       "      <td>Redis从入门到项目实战</td>\n",
       "      <td>https://edu.csdn.net/course/detail/5024</td>\n",
       "      <td>https://img-bss.csdn.net/201706011713499129.png</td>\n",
       "      <td>肖海鹏</td>\n",
       "      <td>20</td>\n",
       "      <td>58.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>141</td>\n",
       "      <td>项目实战：SSO单点登录方案</td>\n",
       "      <td>https://edu.csdn.net/course/detail/6721</td>\n",
       "      <td>https://img-bss.csdn.net/201712151955542670.png</td>\n",
       "      <td>肖海鹏</td>\n",
       "      <td>12</td>\n",
       "      <td>118.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>142</td>\n",
       "      <td>C++动态链接库视频教程（Windows动...</td>\n",
       "      <td>https://edu.csdn.net/course/detail/6664</td>\n",
       "      <td>https://img-bss.csdn.net/201712110030522584.jpg</td>\n",
       "      <td>黄强</td>\n",
       "      <td>15</td>\n",
       "      <td>99.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>143</td>\n",
       "      <td>跟着王进老师学开发之C#篇：基础语法</td>\n",
       "      <td>https://edu.csdn.net/course/detail/4878</td>\n",
       "      <td>https://img-bss.csdn.net/201705081010161985.jpg</td>\n",
       "      <td>王进</td>\n",
       "      <td>74</td>\n",
       "      <td>199.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>144</td>\n",
       "      <td>C++基础入门</td>\n",
       "      <td>https://edu.csdn.net/course/detail/6844</td>\n",
       "      <td>https://img-bss.csdn.net/201805280745341839.jpg</td>\n",
       "      <td>欧阳春晖</td>\n",
       "      <td>27</td>\n",
       "      <td>99.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>145</td>\n",
       "      <td>STL模板编程</td>\n",
       "      <td>https://edu.csdn.net/course/detail/6819</td>\n",
       "      <td>https://img-bss.csdn.net/201712302226582034.</td>\n",
       "      <td>杨波</td>\n",
       "      <td>31</td>\n",
       "      <td>1680.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>146</td>\n",
       "      <td>面向服务的架构(SOA)从入门到实战</td>\n",
       "      <td>https://edu.csdn.net/course/detail/6801</td>\n",
       "      <td>https://img-bss.csdn.net/201712281547056603.</td>\n",
       "      <td>张勇</td>\n",
       "      <td>120</td>\n",
       "      <td>1080.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>147</td>\n",
       "      <td>Django项目实战</td>\n",
       "      <td>https://edu.csdn.net/course/detail/6680</td>\n",
       "      <td>https://img-bss.csdn.net/201712121607428824.png</td>\n",
       "      <td>郭宏志</td>\n",
       "      <td>27</td>\n",
       "      <td>328.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>148</td>\n",
       "      <td>疯狂Spring Cloud微服务教程</td>\n",
       "      <td>https://edu.csdn.net/course/detail/6415</td>\n",
       "      <td>https://img-bss.csdn.net/201711060910532529.png</td>\n",
       "      <td>杨恩雄</td>\n",
       "      <td>36</td>\n",
       "      <td>245.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>149</td>\n",
       "      <td>C++编程视频教程—史上学的最轻松的...</td>\n",
       "      <td>https://edu.csdn.net/course/detail/6200</td>\n",
       "      <td>https://img-bss.csdn.net/201710082240403996.jpg</td>\n",
       "      <td>黄强</td>\n",
       "      <td>59</td>\n",
       "      <td>150.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>150</td>\n",
       "      <td>MyBatis视频—国内首套：源码级讲授...</td>\n",
       "      <td>https://edu.csdn.net/course/detail/4662</td>\n",
       "      <td>https://img-bss.csdn.net/201704111331347270.jpg</td>\n",
       "      <td>雷丰阳</td>\n",
       "      <td>88</td>\n",
       "      <td>99.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>151</td>\n",
       "      <td>最火框架springmvc4+mybatis3+echar...</td>\n",
       "      <td>https://edu.csdn.net/course/detail/4468</td>\n",
       "      <td>https://img-bss.csdn.net/201806140503102804.jpg</td>\n",
       "      <td>Array老师</td>\n",
       "      <td>40</td>\n",
       "      <td>259.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>152</td>\n",
       "      <td>C++socket网络编程大全实战http服务...</td>\n",
       "      <td>https://edu.csdn.net/course/detail/4358</td>\n",
       "      <td>https://img-bss.csdn.net/201703071621541009.png</td>\n",
       "      <td>夏曹俊</td>\n",
       "      <td>69</td>\n",
       "      <td>128.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>153</td>\n",
       "      <td>PLSQL语言</td>\n",
       "      <td>https://edu.csdn.net/course/detail/3948</td>\n",
       "      <td>https://img-bss.csdn.net/201701312044314947.jpg</td>\n",
       "      <td>刘建</td>\n",
       "      <td>53</td>\n",
       "      <td>50.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>154</td>\n",
       "      <td>Thinkphp5实战开发企业官网【含auth...</td>\n",
       "      <td>https://edu.csdn.net/course/detail/3802</td>\n",
       "      <td>https://img-bss.csdn.net/201701141125213829.png</td>\n",
       "      <td>童芳</td>\n",
       "      <td>65</td>\n",
       "      <td>60.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>155</td>\n",
       "      <td>秒学面向对象视频课程（C++高级实践...</td>\n",
       "      <td>https://edu.csdn.net/course/detail/1586</td>\n",
       "      <td>https://img-bss.csdn.net/201511251103209098.jpg</td>\n",
       "      <td>师占标</td>\n",
       "      <td>35</td>\n",
       "      <td>99.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>156</td>\n",
       "      <td>大型ERP实战项目教程</td>\n",
       "      <td>https://edu.csdn.net/course/detail/4390</td>\n",
       "      <td>https://img-bss.csdn.net/201703101449551547.jpg</td>\n",
       "      <td>任亮</td>\n",
       "      <td>115</td>\n",
       "      <td>1299.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>157</td>\n",
       "      <td>ORACLE11g数据库安装</td>\n",
       "      <td>https://edu.csdn.net/course/detail/3945</td>\n",
       "      <td>https://img-bss.csdn.net/201701311920127350.jpg</td>\n",
       "      <td>刘建</td>\n",
       "      <td>15</td>\n",
       "      <td>50.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>158</td>\n",
       "      <td>深入浅出C++程序设计（基础篇）</td>\n",
       "      <td>https://edu.csdn.net/course/detail/4637</td>\n",
       "      <td>https://img-bss.csdn.net/201704072146114287.jpg</td>\n",
       "      <td>李建祥</td>\n",
       "      <td>93</td>\n",
       "      <td>16.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>159</td>\n",
       "      <td>ffmpeg+sdl 音视频播放器</td>\n",
       "      <td>https://edu.csdn.net/course/detail/8752</td>\n",
       "      <td>https://img-bss.csdn.net/201875173152223_89805...</td>\n",
       "      <td>张利</td>\n",
       "      <td>21</td>\n",
       "      <td>59.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>160</td>\n",
       "      <td>Struts2入门到精通</td>\n",
       "      <td>https://edu.csdn.net/course/detail/8731</td>\n",
       "      <td>https://img-bss.csdn.net/201874175259315_17364...</td>\n",
       "      <td>杨千锋</td>\n",
       "      <td>59</td>\n",
       "      <td>89.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>161</td>\n",
       "      <td>ActiveMq由浅入深讲解+面试题50道讲解</td>\n",
       "      <td>https://edu.csdn.net/course/detail/8725</td>\n",
       "      <td>https://img-bss.csdn.net/2018741521176_51850.p...</td>\n",
       "      <td>张立坤</td>\n",
       "      <td>36</td>\n",
       "      <td>169.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>162</td>\n",
       "      <td>Solr构建分布式搜索+面试题讲解</td>\n",
       "      <td>https://edu.csdn.net/course/detail/8722</td>\n",
       "      <td>https://img-bss.csdn.net/201874144033120_20063...</td>\n",
       "      <td>张立坤</td>\n",
       "      <td>26</td>\n",
       "      <td>199.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>163</td>\n",
       "      <td>网络云盘项目实战</td>\n",
       "      <td>https://edu.csdn.net/course/detail/8721</td>\n",
       "      <td>https://img-bss.csdn.net/201874122836427_68602...</td>\n",
       "      <td>王建立</td>\n",
       "      <td>12</td>\n",
       "      <td>25.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>164</td>\n",
       "      <td>Lucene全文检索框架+Solr搜索引擎（...</td>\n",
       "      <td>https://edu.csdn.net/course/detail/8719</td>\n",
       "      <td>https://img-bss.csdn.net/20187410413116_28267....</td>\n",
       "      <td>Long</td>\n",
       "      <td>28</td>\n",
       "      <td>28.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>165</td>\n",
       "      <td>Shiro入门视频课程（最适合初学者的...</td>\n",
       "      <td>https://edu.csdn.net/course/detail/8713</td>\n",
       "      <td>https://img-bss.csdn.net/201873154644236_57234...</td>\n",
       "      <td>汤小洋</td>\n",
       "      <td>13</td>\n",
       "      <td>16.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>166</td>\n",
       "      <td>微信小程序电商实战</td>\n",
       "      <td>https://edu.csdn.net/course/detail/8711</td>\n",
       "      <td>https://img-bss.csdn.net/201872192341519_16139...</td>\n",
       "      <td>lampol</td>\n",
       "      <td>32</td>\n",
       "      <td>99.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>167</td>\n",
       "      <td>Apache Shiro安全框架深入讲解+面试题+案例</td>\n",
       "      <td>https://edu.csdn.net/course/detail/8708</td>\n",
       "      <td>https://img-bss.csdn.net/20187216202471_97389....</td>\n",
       "      <td>张立坤</td>\n",
       "      <td>24</td>\n",
       "      <td>199.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>168</td>\n",
       "      <td>springboot 2.0快速构建微服务系统</td>\n",
       "      <td>https://edu.csdn.net/course/detail/8706</td>\n",
       "      <td>https://img-bss.csdn.net/201872155424611_85028...</td>\n",
       "      <td>张立坤</td>\n",
       "      <td>40</td>\n",
       "      <td>199.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>169</td>\n",
       "      <td>dubbo+zookeeper构建分布式微服务系...</td>\n",
       "      <td>https://edu.csdn.net/course/detail/8704</td>\n",
       "      <td>https://img-bss.csdn.net/201872152241991_76001...</td>\n",
       "      <td>张立坤</td>\n",
       "      <td>49</td>\n",
       "      <td>299.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>170</td>\n",
       "      <td>Python全栈工程师特训班第七期-直播回放</td>\n",
       "      <td>https://edu.csdn.net/course/detail/8702</td>\n",
       "      <td>https://img-bss.csdn.net/201872145429859_14793...</td>\n",
       "      <td>CSDN就业班</td>\n",
       "      <td>2</td>\n",
       "      <td>12000.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>171</td>\n",
       "      <td>精通Python C编程</td>\n",
       "      <td>https://edu.csdn.net/course/detail/8701</td>\n",
       "      <td>https://img-bss.csdn.net/20187214755876_66176....</td>\n",
       "      <td>苏劲</td>\n",
       "      <td>36</td>\n",
       "      <td>198.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>172</td>\n",
       "      <td>Python开发Socket服务端框架</td>\n",
       "      <td>https://edu.csdn.net/course/detail/8700</td>\n",
       "      <td>https://img-bss.csdn.net/201872134939279_1810....</td>\n",
       "      <td>苏劲</td>\n",
       "      <td>19</td>\n",
       "      <td>288.00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     id                             title  \\\n",
       "0   116           FFMpeg视频开发与应用基础——使用F...   \n",
       "1   117                        Java8零基础入门   \n",
       "2   118                  项目实战：大型分布式连锁酒店系统   \n",
       "3   119                    C语言大型软件设计的面向对象   \n",
       "4   120                Spring Cloud 微服务实战   \n",
       "5   121                      Python基础快速入门   \n",
       "6   122                       深度解剖dubbo源码   \n",
       "7   123                  Python机器学习经典案例实战   \n",
       "8   124               Python数据分析与挖掘经典案例实战   \n",
       "9   125                     MATLAB基础知识大串讲   \n",
       "10  126                       Lua语言从入门到精通   \n",
       "11  127                     华为工程师，带你实战C++   \n",
       "12  128                    JFinal极速开发企业实战   \n",
       "13  129                        C语言及程序设计进阶   \n",
       "14  130                           C++语言基础   \n",
       "15  131                      Spring MVC视频   \n",
       "16  132              使用swing、三层架构实现学生管理系统   \n",
       "17  133                      分布式动态数据源切换攻略   \n",
       "18  134           大型Java项目视频教程_王勇老师DRP...   \n",
       "19  135   基于Maven+ SpringMVC+ MyBatis ...   \n",
       "20  136             零基础学会在Linux上编译调试C++项目   \n",
       "21  137                        计算机科学与编程导论   \n",
       "22  138             VC++Windows多线程实战图片编辑器   \n",
       "23  139             深入浅出C语言（配套完整习题 + 源代码）   \n",
       "24  140                     Redis从入门到项目实战   \n",
       "25  141                    项目实战：SSO单点登录方案   \n",
       "26  142          C++动态链接库视频教程（Windows动...   \n",
       "27  143                跟着王进老师学开发之C#篇：基础语法   \n",
       "28  144                           C++基础入门   \n",
       "29  145                           STL模板编程   \n",
       "30  146                面向服务的架构(SOA)从入门到实战   \n",
       "31  147                        Django项目实战   \n",
       "32  148               疯狂Spring Cloud微服务教程   \n",
       "33  149             C++编程视频教程—史上学的最轻松的...   \n",
       "34  150           MyBatis视频—国内首套：源码级讲授...   \n",
       "35  151  最火框架springmvc4+mybatis3+echar...   \n",
       "36  152        C++socket网络编程大全实战http服务...   \n",
       "37  153                           PLSQL语言   \n",
       "38  154        Thinkphp5实战开发企业官网【含auth...   \n",
       "39  155             秒学面向对象视频课程（C++高级实践...   \n",
       "40  156                       大型ERP实战项目教程   \n",
       "41  157                    ORACLE11g数据库安装   \n",
       "42  158                  深入浅出C++程序设计（基础篇）   \n",
       "43  159                 ffmpeg+sdl 音视频播放器   \n",
       "44  160                      Struts2入门到精通   \n",
       "45  161           ActiveMq由浅入深讲解+面试题50道讲解   \n",
       "46  162                 Solr构建分布式搜索+面试题讲解   \n",
       "47  163                          网络云盘项目实战   \n",
       "48  164         Lucene全文检索框架+Solr搜索引擎（...   \n",
       "49  165            Shiro入门视频课程（最适合初学者的...   \n",
       "50  166                         微信小程序电商实战   \n",
       "51  167       Apache Shiro安全框架深入讲解+面试题+案例   \n",
       "52  168           springboot 2.0快速构建微服务系统   \n",
       "53  169       dubbo+zookeeper构建分布式微服务系...   \n",
       "54  170            Python全栈工程师特训班第七期-直播回放   \n",
       "55  171                      精通Python C编程   \n",
       "56  172               Python开发Socket服务端框架   \n",
       "\n",
       "                                        url  \\\n",
       "0   https://edu.csdn.net/course/detail/2515   \n",
       "1   https://edu.csdn.net/course/detail/3044   \n",
       "2   https://edu.csdn.net/course/detail/3935   \n",
       "3   https://edu.csdn.net/course/detail/6496   \n",
       "4   https://edu.csdn.net/course/detail/5840   \n",
       "5   https://edu.csdn.net/course/detail/5814   \n",
       "6   https://edu.csdn.net/course/detail/5475   \n",
       "7   https://edu.csdn.net/course/detail/4531   \n",
       "8   https://edu.csdn.net/course/detail/3569   \n",
       "9   https://edu.csdn.net/course/detail/3527   \n",
       "10  https://edu.csdn.net/course/detail/2994   \n",
       "11  https://edu.csdn.net/course/detail/2322   \n",
       "12  https://edu.csdn.net/course/detail/1968   \n",
       "13   https://edu.csdn.net/course/detail/504   \n",
       "14   https://edu.csdn.net/course/detail/474   \n",
       "15   https://edu.csdn.net/course/detail/408   \n",
       "16  https://edu.csdn.net/course/detail/5573   \n",
       "17  https://edu.csdn.net/course/detail/6291   \n",
       "18  https://edu.csdn.net/course/detail/6608   \n",
       "19  https://edu.csdn.net/course/detail/6936   \n",
       "20  https://edu.csdn.net/course/detail/3738   \n",
       "21  https://edu.csdn.net/course/detail/3523   \n",
       "22  https://edu.csdn.net/course/detail/3685   \n",
       "23  https://edu.csdn.net/course/detail/4571   \n",
       "24  https://edu.csdn.net/course/detail/5024   \n",
       "25  https://edu.csdn.net/course/detail/6721   \n",
       "26  https://edu.csdn.net/course/detail/6664   \n",
       "27  https://edu.csdn.net/course/detail/4878   \n",
       "28  https://edu.csdn.net/course/detail/6844   \n",
       "29  https://edu.csdn.net/course/detail/6819   \n",
       "30  https://edu.csdn.net/course/detail/6801   \n",
       "31  https://edu.csdn.net/course/detail/6680   \n",
       "32  https://edu.csdn.net/course/detail/6415   \n",
       "33  https://edu.csdn.net/course/detail/6200   \n",
       "34  https://edu.csdn.net/course/detail/4662   \n",
       "35  https://edu.csdn.net/course/detail/4468   \n",
       "36  https://edu.csdn.net/course/detail/4358   \n",
       "37  https://edu.csdn.net/course/detail/3948   \n",
       "38  https://edu.csdn.net/course/detail/3802   \n",
       "39  https://edu.csdn.net/course/detail/1586   \n",
       "40  https://edu.csdn.net/course/detail/4390   \n",
       "41  https://edu.csdn.net/course/detail/3945   \n",
       "42  https://edu.csdn.net/course/detail/4637   \n",
       "43  https://edu.csdn.net/course/detail/8752   \n",
       "44  https://edu.csdn.net/course/detail/8731   \n",
       "45  https://edu.csdn.net/course/detail/8725   \n",
       "46  https://edu.csdn.net/course/detail/8722   \n",
       "47  https://edu.csdn.net/course/detail/8721   \n",
       "48  https://edu.csdn.net/course/detail/8719   \n",
       "49  https://edu.csdn.net/course/detail/8713   \n",
       "50  https://edu.csdn.net/course/detail/8711   \n",
       "51  https://edu.csdn.net/course/detail/8708   \n",
       "52  https://edu.csdn.net/course/detail/8706   \n",
       "53  https://edu.csdn.net/course/detail/8704   \n",
       "54  https://edu.csdn.net/course/detail/8702   \n",
       "55  https://edu.csdn.net/course/detail/8701   \n",
       "56  https://edu.csdn.net/course/detail/8700   \n",
       "\n",
       "                                                  pic  teacher time     price  \n",
       "0     https://img-bss.csdn.net/201606131053129326.jpg      殷汶杰   21     50.00  \n",
       "1     https://img-bss.csdn.net/201805100755115951.jpg      肖海鹏   40      1.20  \n",
       "2     https://img-bss.csdn.net/201706011726012883.png      肖海鹏   54    577.00  \n",
       "3     https://img-bss.csdn.net/201711171518014819.png      宋宝华    1     65.00  \n",
       "4     https://img-bss.csdn.net/201709051544372665.jpg      王浩彬   18    268.00  \n",
       "5     https://img-bss.csdn.net/201708311438433250.jpg       黄勇  117    129.00  \n",
       "6     https://img-bss.csdn.net/201801290929025603.jpg  卢铄波(阿甘）   30    469.00  \n",
       "7     https://img-bss.csdn.net/201703240854465699.jpg       韦玮    5    299.00  \n",
       "8     https://img-bss.csdn.net/201612301543471953.jpg       韦玮   36    199.00  \n",
       "9     https://img-bss.csdn.net/201612271504381160.png       魏伟   60     30.00  \n",
       "10    https://img-bss.csdn.net/201609201310378738.png       杨振   66     15.00  \n",
       "11    https://img-bss.csdn.net/201605061231337444.jpg      王桂林   81     25.00  \n",
       "12    https://img-bss.csdn.net/201601220918102784.jpg  牟孟孟（小木）  100    260.00  \n",
       "13    https://img-bss.csdn.net/201503141137247000.png      贺利坚   43     30.00  \n",
       "14    https://img-bss.csdn.net/201503010255312402.png      贺利坚   87     75.00  \n",
       "15    https://img-bss.csdn.net/201502100255203210.jpg       佟刚   60     25.00  \n",
       "16    https://img-bss.csdn.net/201708121505163007.png      马亚军   25    299.00  \n",
       "17    https://img-bss.csdn.net/201803191642534078.png  Array老师   23    109.00  \n",
       "18    https://img-bss.csdn.net/201712052038189430.jpg       王勇  292    299.00  \n",
       "19    https://img-bss.csdn.net/201801161228103095.jpg      易拙言   43     99.00  \n",
       "20    https://img-bss.csdn.net/201701111403485497.png      夏曹俊   32     48.00  \n",
       "21    https://img-bss.csdn.net/201612262224358345.jpg       杨波   14     98.00  \n",
       "22    https://img-bss.csdn.net/201701051654056277.png      夏曹俊   23     89.00  \n",
       "23   https://img-bss.csdn.net/201703291640393490.jpeg      林世霖   31     69.00  \n",
       "24    https://img-bss.csdn.net/201706011713499129.png      肖海鹏   20     58.00  \n",
       "25    https://img-bss.csdn.net/201712151955542670.png      肖海鹏   12    118.00  \n",
       "26    https://img-bss.csdn.net/201712110030522584.jpg       黄强   15     99.00  \n",
       "27    https://img-bss.csdn.net/201705081010161985.jpg       王进   74    199.00  \n",
       "28    https://img-bss.csdn.net/201805280745341839.jpg     欧阳春晖   27     99.00  \n",
       "29       https://img-bss.csdn.net/201712302226582034.       杨波   31   1680.00  \n",
       "30       https://img-bss.csdn.net/201712281547056603.       张勇  120   1080.00  \n",
       "31    https://img-bss.csdn.net/201712121607428824.png      郭宏志   27    328.00  \n",
       "32    https://img-bss.csdn.net/201711060910532529.png      杨恩雄   36    245.00  \n",
       "33    https://img-bss.csdn.net/201710082240403996.jpg       黄强   59    150.00  \n",
       "34    https://img-bss.csdn.net/201704111331347270.jpg      雷丰阳   88     99.00  \n",
       "35    https://img-bss.csdn.net/201806140503102804.jpg  Array老师   40    259.00  \n",
       "36    https://img-bss.csdn.net/201703071621541009.png      夏曹俊   69    128.00  \n",
       "37    https://img-bss.csdn.net/201701312044314947.jpg       刘建   53     50.00  \n",
       "38    https://img-bss.csdn.net/201701141125213829.png       童芳   65     60.00  \n",
       "39    https://img-bss.csdn.net/201511251103209098.jpg      师占标   35     99.00  \n",
       "40    https://img-bss.csdn.net/201703101449551547.jpg       任亮  115   1299.00  \n",
       "41    https://img-bss.csdn.net/201701311920127350.jpg       刘建   15     50.00  \n",
       "42    https://img-bss.csdn.net/201704072146114287.jpg      李建祥   93     16.00  \n",
       "43  https://img-bss.csdn.net/201875173152223_89805...       张利   21     59.00  \n",
       "44  https://img-bss.csdn.net/201874175259315_17364...      杨千锋   59     89.00  \n",
       "45  https://img-bss.csdn.net/2018741521176_51850.p...      张立坤   36    169.00  \n",
       "46  https://img-bss.csdn.net/201874144033120_20063...      张立坤   26    199.00  \n",
       "47  https://img-bss.csdn.net/201874122836427_68602...      王建立   12     25.00  \n",
       "48  https://img-bss.csdn.net/20187410413116_28267....     Long   28     28.00  \n",
       "49  https://img-bss.csdn.net/201873154644236_57234...      汤小洋   13     16.00  \n",
       "50  https://img-bss.csdn.net/201872192341519_16139...   lampol   32     99.00  \n",
       "51  https://img-bss.csdn.net/20187216202471_97389....      张立坤   24    199.00  \n",
       "52  https://img-bss.csdn.net/201872155424611_85028...      张立坤   40    199.00  \n",
       "53  https://img-bss.csdn.net/201872152241991_76001...      张立坤   49    299.00  \n",
       "54  https://img-bss.csdn.net/201872145429859_14793...  CSDN就业班    2  12000.00  \n",
       "55  https://img-bss.csdn.net/20187214755876_66176....       苏劲   36    198.00  \n",
       "56  https://img-bss.csdn.net/201872134939279_1810....       苏劲   19    288.00  "
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pymysql\n",
    "conn = pymysql.connect(host='localhost', user='root', password='', db='csdndb', charset='utf8')\n",
    "sql = 'select * from courses'\n",
    "data = pd.read_sql(sql, conn)\n",
    "conn.close()\n",
    "data"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 加载MongoDB数据"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "MongoClient(host=['localhost:27017'], document_class=dict, tz_aware=False, connect=True)"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pymongo\n",
    "client = pymongo.MongoClient('localhost', 27017)\n",
    "client"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>_id</th>\n",
       "      <th>comment_num</th>\n",
       "      <th>detail_url</th>\n",
       "      <th>image</th>\n",
       "      <th>price</th>\n",
       "      <th>promo_words</th>\n",
       "      <th>shop</th>\n",
       "      <th>title</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>5b518331284df258cc4ef5ce</td>\n",
       "      <td>16万+</td>\n",
       "      <td>https://item.jd.com/7418428.html</td>\n",
       "      <td>https://img13.360buyimg.com/n7/jfs/t20974/205/...</td>\n",
       "      <td>7299.00</td>\n",
       "      <td>【薄然“新”动，轻薄专场】信仰“Y” Logo灯效，超窄边全面屏，TSI散热，CPU显卡性能...</td>\n",
       "      <td>联想电脑京东自营旗舰店</td>\n",
       "      <td>联想(Lenovo)拯救者Y7000 15.6英寸游戏笔记本电脑(英特尔八代酷睿i7-875...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>5b51836d284df258cc4ef5cf</td>\n",
       "      <td>21万+</td>\n",
       "      <td>https://item.jd.com/5225346.html</td>\n",
       "      <td>https://img11.360buyimg.com/n7/jfs/t14848/365/...</td>\n",
       "      <td>6498.00</td>\n",
       "      <td>【新品享6期白条免息】新MacBook Pro，一强再强，八代处理器满血归来！活动期间下单新...</td>\n",
       "      <td>京东Apple产品专营店</td>\n",
       "      <td>Apple MacBook Air 13.3英寸笔记本电脑 银色(2017款Core i5 ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>5b5183a9284df258cc4ef5d0</td>\n",
       "      <td>16万+</td>\n",
       "      <td>https://item.jd.com/5512841.html</td>\n",
       "      <td>https://img11.360buyimg.com/n7/jfs/t14947/152/...</td>\n",
       "      <td>5499.00</td>\n",
       "      <td>【薄然“新”动，轻薄专场】荣誉勋章，SSD+HDD双硬盘，支持M.2接口固态硬盘，两级可调背...</td>\n",
       "      <td>联想电脑京东自营旗舰店</td>\n",
       "      <td>联想(Lenovo)拯救者R720 15.6英寸大屏游戏笔记本电脑(i5-7300HQ 8G...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>5b5183a9284df258cc4ef5d1</td>\n",
       "      <td>9600+</td>\n",
       "      <td>https://item.jd.com/7512626.html</td>\n",
       "      <td>https://img11.360buyimg.com/n7/jfs/t21502/75/4...</td>\n",
       "      <td>3999.00</td>\n",
       "      <td>荣耀AMD锐龙5新品，金属微边框轻薄本，薄至15.8mm，护眼全高清IPS屏，57.4Wh大...</td>\n",
       "      <td>荣耀京东自营旗舰店</td>\n",
       "      <td>荣耀MagicBook 14英寸轻薄窄边框笔记本电脑（AMD锐龙5 8G 256G FHD ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5b5183e5284df258cc4ef5d2</td>\n",
       "      <td>21万+</td>\n",
       "      <td>https://item.jd.com/4335139.html</td>\n",
       "      <td>https://img14.360buyimg.com/n7/jfs/t17278/112/...</td>\n",
       "      <td>7898.00</td>\n",
       "      <td>【新品享6期白条免息】新MacBook Pro，一强再强，八代处理器满血归来！活动期间下单新...</td>\n",
       "      <td>京东Apple产品专营店</td>\n",
       "      <td>Apple MacBook Air 13.3英寸笔记本电脑 银色(2017款Core i5 ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5b5183e5284df258cc4ef5d3</td>\n",
       "      <td>16万+</td>\n",
       "      <td>https://item.jd.com/7632577.html</td>\n",
       "      <td>https://img12.360buyimg.com/n7/jfs/t21313/152/...</td>\n",
       "      <td>6499.00</td>\n",
       "      <td>【薄然“新”动，轻薄专场】信仰“Y” Logo灯效，超窄边全面屏，TSI散热，CPU显卡性能...</td>\n",
       "      <td>联想电脑京东自营旗舰店</td>\n",
       "      <td>联想(Lenovo)拯救者Y7000 15.6英寸游戏笔记本电脑(英特尔八代酷睿i5-830...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>5b518421284df258cc4ef5d4</td>\n",
       "      <td>2.6万+</td>\n",
       "      <td>https://item.jd.com/7341442.html</td>\n",
       "      <td>https://img12.360buyimg.com/n7/jfs/t19939/363/...</td>\n",
       "      <td>5999.00</td>\n",
       "      <td>八代标压，1050Ti，防眩光全高清屏，HDMI 2.0 4K 输出</td>\n",
       "      <td>戴尔京东官方自营旗舰店</td>\n",
       "      <td>戴尔DELL游匣G3 15.6英寸游戏笔记本电脑(i5-8300H 8G 128GSSD+1...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>5b518421284df258cc4ef5d5</td>\n",
       "      <td>7万+</td>\n",
       "      <td>https://item.jd.com/7435156.html</td>\n",
       "      <td>https://img11.360buyimg.com/n7/jfs/t20992/243/...</td>\n",
       "      <td>7699.00</td>\n",
       "      <td>【暗影精灵4】微边框游戏本搭载8代处理器，白条6期免息》微边框电竞游戏本-暗影4</td>\n",
       "      <td>惠普京东自营官方旗舰店</td>\n",
       "      <td>惠普（HP）暗影精灵4代 15.6英寸游戏笔记本电脑（i5-8300H 8G 128G+1T...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>5b51845d284df258cc4ef5d6</td>\n",
       "      <td>12万+</td>\n",
       "      <td>https://item.jd.com/5148309.html</td>\n",
       "      <td>https://img14.360buyimg.com/n7/jfs/t11542/236/...</td>\n",
       "      <td>5399.00</td>\n",
       "      <td>【经典再升级,三边全景7mm微边框】77% 超高屏占比,八代处理器,全新MX150 2G独显...</td>\n",
       "      <td>戴尔京东官方自营旗舰店</td>\n",
       "      <td>戴尔DELL灵越燃7000 II 14.0英寸轻薄窄边框笔记本电脑(i5-8250U 8G ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>5b51845d284df258cc4ef5d7</td>\n",
       "      <td>7.8万+</td>\n",
       "      <td>https://item.jd.com/6072622.html</td>\n",
       "      <td>https://img12.360buyimg.com/n7/jfs/t14920/22/1...</td>\n",
       "      <td>5799.00</td>\n",
       "      <td>【自成E派 ThinkPad E485新品发售，Plus专享首发价3999元】</td>\n",
       "      <td>ThinkPad京东自营旗舰店</td>\n",
       "      <td>联想ThinkPad 翼480（0VCD）英特尔8代酷睿14英寸轻薄窄边框笔记本电脑（i5-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>5b518499284df258cc4ef5d8</td>\n",
       "      <td>3.2万+</td>\n",
       "      <td>https://item.jd.com/7271737.html</td>\n",
       "      <td>https://img12.360buyimg.com/n7/jfs/t17458/302/...</td>\n",
       "      <td>4999.00</td>\n",
       "      <td>【暑期特惠】荣耀笔记本，窄边框护眼全高清IPS屏，intel8代CPU+满血版MX150独显...</td>\n",
       "      <td>荣耀京东自营旗舰店</td>\n",
       "      <td>荣耀MagicBook 14英寸轻薄窄边框笔记本电脑（i5-8250U 8G 256G MX...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>5b5184d5284df258cc4ef5d9</td>\n",
       "      <td>16万+</td>\n",
       "      <td>https://item.jd.com/7886481.html</td>\n",
       "      <td>https://img11.360buyimg.com/n7/jfs/t20437/238/...</td>\n",
       "      <td>5799.00</td>\n",
       "      <td>【薄然“新”动，轻薄专场】信仰“Y” Logo灯效，超窄边全面屏，TSI散热，CPU显卡性能...</td>\n",
       "      <td>联想电脑京东自营旗舰店</td>\n",
       "      <td>联想(Lenovo)拯救者Y7000 15.6英寸游戏笔记本电脑(英特尔八代酷睿i5-830...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>5b5184d5284df258cc4ef5da</td>\n",
       "      <td>10万+</td>\n",
       "      <td>https://item.jd.com/5363894.html</td>\n",
       "      <td>https://img14.360buyimg.com/n7/jfs/t20026/165/...</td>\n",
       "      <td>5299.00</td>\n",
       "      <td>【薄然“新”动，轻薄专场】三面微边框全高清IPS屏，轻至1.2Kg，采用intel8代CPU...</td>\n",
       "      <td>联想电脑京东自营旗舰店</td>\n",
       "      <td>联想(Lenovo)小新潮7000 13.3英寸超轻薄窄边框笔记本电脑(i5-8250U 8...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>5b5184d5284df258cc4ef5db</td>\n",
       "      <td>3.8万+</td>\n",
       "      <td>https://item.jd.com/5352358.html</td>\n",
       "      <td>https://img13.360buyimg.com/n7/jfs/t13369/67/5...</td>\n",
       "      <td>5499.00</td>\n",
       "      <td>【GTX1050Ti 4G独显】帧率高稳定性强运行更畅快,IPS防眩光显示屏全面还原游戏战场！</td>\n",
       "      <td>戴尔京东官方自营旗舰店</td>\n",
       "      <td>戴尔DELL灵越游匣Master15.6英寸游戏笔记本电脑(i5-7300HQ 8G 128...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>5b518511284df258cc4ef5dc</td>\n",
       "      <td>6.8万+</td>\n",
       "      <td>https://item.jd.com/5029717.html</td>\n",
       "      <td>https://img12.360buyimg.com/n7/jfs/t17083/327/...</td>\n",
       "      <td>5599.00</td>\n",
       "      <td>【DDR4内存 PCIE固态硬盘 高色域全高清屏】【告别显示器轻装上阵】【15.6英寸MX1...</td>\n",
       "      <td>小米京东官方自营旗舰店</td>\n",
       "      <td>小米(MI)Pro 15.6英寸金属轻薄笔记本(i5-8250U 8G 256GSSD MX...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>5b518511284df258cc4ef5dd</td>\n",
       "      <td>3.2万+</td>\n",
       "      <td>https://item.jd.com/7275691.html</td>\n",
       "      <td>https://img11.360buyimg.com/n7/jfs/t17695/189/...</td>\n",
       "      <td>5699.00</td>\n",
       "      <td>【暑期特惠】荣耀笔记本，窄边框护眼全高清IPS屏，intel8代CPU+满血版MX150独显...</td>\n",
       "      <td>荣耀京东自营旗舰店</td>\n",
       "      <td>荣耀MagicBook 14英寸轻薄窄边框笔记本电脑（i7-8550U 8G 256G MX...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>5b518511284df258cc4ef5de</td>\n",
       "      <td>3.5万+</td>\n",
       "      <td>https://item.jd.com/5834183.html</td>\n",
       "      <td>https://img13.360buyimg.com/n7/jfs/t16543/130/...</td>\n",
       "      <td>4599.00</td>\n",
       "      <td>【轻装造梦】300nit ,72%色域IPS屏,机身至薄处15.81mm,8代处理器,背光键...</td>\n",
       "      <td>戴尔京东官方自营旗舰店</td>\n",
       "      <td>戴尔DELL成就5000不凡银13.3英寸商务办公超轻薄便携笔记本电脑(i5-8250U 8...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>5b51854d284df258cc4ef5df</td>\n",
       "      <td>10万+</td>\n",
       "      <td>https://item.jd.com/7102519.html</td>\n",
       "      <td>https://img14.360buyimg.com/n7/jfs/t22198/64/1...</td>\n",
       "      <td>5799.00</td>\n",
       "      <td>【薄然“新”动，轻薄专场】极简设计风格，2T+128G双混大存储，三边窄边框80.8%屏占比...</td>\n",
       "      <td>联想电脑京东自营旗舰店</td>\n",
       "      <td>联想(Lenovo)小新潮7000 2018款 14英寸轻薄笔记本电脑(英特尔八代酷睿I7-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>5b51854d284df258cc4ef5e0</td>\n",
       "      <td>7万+</td>\n",
       "      <td>https://item.jd.com/7435200.html</td>\n",
       "      <td>https://img10.360buyimg.com/n7/jfs/t20098/264/...</td>\n",
       "      <td>6999.00</td>\n",
       "      <td>【暗影精灵4】微边框游戏本搭载8代处理器，白条6期免息》微边框电竞游戏本-暗影4</td>\n",
       "      <td>惠普京东自营官方旗舰店</td>\n",
       "      <td>惠普（HP）暗影精灵4代 15.6英寸游戏笔记本电脑（i5-8300H 8G 128G+1T...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>5b51858a284df258cc4ef5e1</td>\n",
       "      <td>2.6万+</td>\n",
       "      <td>https://item.jd.com/7555189.html</td>\n",
       "      <td>https://img14.360buyimg.com/n7/jfs/t22294/245/...</td>\n",
       "      <td>7999.00</td>\n",
       "      <td>八代6核i7，1060，制霸全场，畅快”吃鸡”，背光键盘、HDMI 2.0， 雷电3</td>\n",
       "      <td>戴尔京东官方自营旗舰店</td>\n",
       "      <td>戴尔DELL游匣G3 15.6英寸游戏笔记本电脑(i7-8750H 8G 128GSSD+1...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>5b51858a284df258cc4ef5e2</td>\n",
       "      <td>12万+</td>\n",
       "      <td>https://item.jd.com/5148299.html</td>\n",
       "      <td>https://img14.360buyimg.com/n7/jfs/t11719/257/...</td>\n",
       "      <td>6199.00</td>\n",
       "      <td>【经典再升级,三边全景7mm微边框】77% 超高屏占比,八代处理器,全新MX150 2G独显...</td>\n",
       "      <td>戴尔京东官方自营旗舰店</td>\n",
       "      <td>戴尔DELL灵越燃7000 II 14.0英寸轻薄窄边框笔记本电脑(i7-8550U 8G ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>5b5185c6284df258cc4ef5e3</td>\n",
       "      <td>4.6万+</td>\n",
       "      <td>https://item.jd.com/1593516.html</td>\n",
       "      <td>https://img11.360buyimg.com/n7/jfs/t15601/39/1...</td>\n",
       "      <td>14165.00</td>\n",
       "      <td>【新品享6期白条免息】新MacBook Pro，一强再强，八代处理器满血归来！活动期间下单新...</td>\n",
       "      <td>京东Apple产品专营店</td>\n",
       "      <td>Apple MacBook Pro 15.4英寸笔记本电脑 银色(Core i7 处理器/1...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>5b5185c6284df258cc4ef5e4</td>\n",
       "      <td>7万+</td>\n",
       "      <td>https://item.jd.com/7649679.html</td>\n",
       "      <td>https://img14.360buyimg.com/n7/jfs/t20014/242/...</td>\n",
       "      <td>6499.00</td>\n",
       "      <td>【暗影精灵4】微边框游戏本搭载8代处理器，白条6期免息》微边框电竞游戏本-暗影4</td>\n",
       "      <td>惠普京东自营官方旗舰店</td>\n",
       "      <td>惠普（HP）暗影精灵4代 15.6英寸游戏笔记本电脑（i5-8300H 8G 128G+1T...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>5b518602284df258cc4ef5e5</td>\n",
       "      <td>7万+</td>\n",
       "      <td>https://item.jd.com/7435168.html</td>\n",
       "      <td>https://img13.360buyimg.com/n7/jfs/t21868/340/...</td>\n",
       "      <td>9999.00</td>\n",
       "      <td>【暗影精灵4】微边框游戏本搭载8代处理器，白条6期免息》微边框电竞游戏本-暗影4</td>\n",
       "      <td>惠普京东自营官方旗舰店</td>\n",
       "      <td>惠普（HP）暗影精灵4代 15.6英寸游戏笔记本电脑（i7-8750H 16G 128G+1...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>5b518602284df258cc4ef5e6</td>\n",
       "      <td>2.1万+</td>\n",
       "      <td>https://item.jd.com/6830412.html</td>\n",
       "      <td>https://img12.360buyimg.com/n7/jfs/t20722/13/5...</td>\n",
       "      <td>8299.00</td>\n",
       "      <td>【白条3期免息】144Hz电竞屏，八代i7+GTX1060电竞旗舰，光轴机械键盘机械革命笔记...</td>\n",
       "      <td>机械革命京东自营官方旗舰店</td>\n",
       "      <td>机械革命(MECHREVO)X8Ti 8代酷睿i7-8750H GTX1060 144Hz7...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>5b51863e284df258cc4ef5e7</td>\n",
       "      <td>9200+</td>\n",
       "      <td>https://item.jd.com/3948470.html</td>\n",
       "      <td>https://img10.360buyimg.com/n7/jfs/t16117/315/...</td>\n",
       "      <td>4799.00</td>\n",
       "      <td>【自成E派 ThinkPad E485新品发售，Plus专享首发价3999元】</td>\n",
       "      <td>ThinkPad京东自营旗舰店</td>\n",
       "      <td>联想ThinkPad E470（1RCD）英特尔7代酷睿14英寸笔记本电脑（i5-7200U...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>5b51863e284df258cc4ef5e8</td>\n",
       "      <td>12万+</td>\n",
       "      <td>https://item.jd.com/5148275.html</td>\n",
       "      <td>https://img10.360buyimg.com/n7/jfs/t10453/85/2...</td>\n",
       "      <td>4999.00</td>\n",
       "      <td>【经典再升级,三边全景7mm微边框】77% 超高屏占比,八代处理器,SSD固态硬盘快速响应,...</td>\n",
       "      <td>戴尔京东官方自营旗舰店</td>\n",
       "      <td>戴尔DELL灵越燃7000 II 14.0英寸轻薄窄边框笔记本电脑(i5-8250U 8G ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>5b51867a284df258cc4ef5e9</td>\n",
       "      <td>10万+</td>\n",
       "      <td>https://item.jd.com/6888588.html</td>\n",
       "      <td>https://img13.360buyimg.com/n7/jfs/t24586/261/...</td>\n",
       "      <td>5099.00</td>\n",
       "      <td>【薄然“新”动，轻薄专场】极简设计风格，2T+128G双混大存储，三边窄边框80.8%屏占比...</td>\n",
       "      <td>联想电脑京东自营旗舰店</td>\n",
       "      <td>联想(Lenovo)小新潮7000 14英寸轻薄笔记本电脑(英特尔八代酷睿I5-8250U ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>5b51867a284df258cc4ef5ea</td>\n",
       "      <td>4.5万+</td>\n",
       "      <td>https://item.jd.com/4315329.html</td>\n",
       "      <td>https://img14.360buyimg.com/n7/jfs/t21028/72/1...</td>\n",
       "      <td>4999.00</td>\n",
       "      <td>【7/20号迎新爆秒24小时！】三面金属机身轻薄本！性能金刚，颜值芭比！灵耀S 2代新品预约...</td>\n",
       "      <td>华硕京东自营官方旗舰店</td>\n",
       "      <td>华硕(ASUS) 灵耀U4000UQ 14英寸合金机身轻薄笔记本电脑(i5-7200U 8G...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>5b51867a284df258cc4ef5eb</td>\n",
       "      <td>7万+</td>\n",
       "      <td>https://item.jd.com/7649609.html</td>\n",
       "      <td>https://img14.360buyimg.com/n7/jfs/t20971/284/...</td>\n",
       "      <td>9299.00</td>\n",
       "      <td>【暗影精灵4】微边框游戏本搭载8代处理器，白条6期免息》微边框电竞游戏本-暗影4</td>\n",
       "      <td>惠普京东自营官方旗舰店</td>\n",
       "      <td>惠普（HP）暗影精灵4代 15.6英寸游戏笔记本电脑（i7-8750H 8G 128G+1T...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>5b5186b6284df258cc4ef5ec</td>\n",
       "      <td>1万+</td>\n",
       "      <td>https://item.jd.com/6736174.html</td>\n",
       "      <td>https://img14.360buyimg.com/n7/jfs/t24517/167/...</td>\n",
       "      <td>5788.00</td>\n",
       "      <td>【7/20号迎新爆秒24小时！】新8代CPU/PCIE硬盘，比它们快一些的高速硬盘！灵耀S ...</td>\n",
       "      <td>华硕京东自营官方旗舰店</td>\n",
       "      <td>华硕(ASUS) 飞行堡垒五代FX80 15.6英寸游戏笔记本电脑(i5-8300H 8G ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>5b5186b6284df258cc4ef5ed</td>\n",
       "      <td>1.8万+</td>\n",
       "      <td>https://item.jd.com/5537833.html</td>\n",
       "      <td>https://img13.360buyimg.com/n7/jfs/t11191/117/...</td>\n",
       "      <td>6388.00</td>\n",
       "      <td></td>\n",
       "      <td>微软官方自营旗舰店</td>\n",
       "      <td>微软（Microsoft）新Surface Pro 二合一平板电脑 12.3英寸（Intel...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>5b5186b6284df258cc4ef5ee</td>\n",
       "      <td>5.4万+</td>\n",
       "      <td>https://item.jd.com/4331155.html</td>\n",
       "      <td>https://img10.360buyimg.com/n7/jfs/t18574/338/...</td>\n",
       "      <td>13698.00</td>\n",
       "      <td>【新品享6期白条免息】新MacBook Pro，一强再强，八代处理器满血归来！活动期间下单新...</td>\n",
       "      <td>京东Apple产品专营店</td>\n",
       "      <td>Apple MacBook Pro 13.3英寸笔记本电脑 深空灰色（2017款Multi-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>5b5186f0284df258cc4ef5ef</td>\n",
       "      <td>10万+</td>\n",
       "      <td>https://item.jd.com/4752515.html</td>\n",
       "      <td>https://img10.360buyimg.com/n7/jfs/t19942/328/...</td>\n",
       "      <td>5499.00</td>\n",
       "      <td>【薄然“新”动，轻薄专场】三面微边框全高清IPS屏，轻至1.2Kg，采用intel8代CPU...</td>\n",
       "      <td>联想电脑京东自营旗舰店</td>\n",
       "      <td>联想(Lenovo)小新潮7000 13.3英寸超轻薄窄边框笔记本电脑(i7-8550U 8...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>5b5186f0284df258cc4ef5f0</td>\n",
       "      <td>6.8万+</td>\n",
       "      <td>https://item.jd.com/5456134.html</td>\n",
       "      <td>https://img14.360buyimg.com/n7/jfs/t18268/295/...</td>\n",
       "      <td>6999.00</td>\n",
       "      <td>【DDR4内存 PCIE固态硬盘 高色域全高清屏】【皇冠级性能本】 第八代酷睿I7处理器 专...</td>\n",
       "      <td>小米京东官方自营旗舰店</td>\n",
       "      <td>小米(MI)Pro 15.6英寸金属轻薄笔记本(i7-8550U 16G 256GSSD M...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>5b5186f0284df258cc4ef5f1</td>\n",
       "      <td>2.1万+</td>\n",
       "      <td>https://item.jd.com/7044365.html</td>\n",
       "      <td>https://img10.360buyimg.com/n7/jfs/t20485/325/...</td>\n",
       "      <td>7997.00</td>\n",
       "      <td>【白条3期免息】八代i7+GTX1060电竞旗舰，轻盈纤薄，颜值窄边框，光轴机械键盘机械革命...</td>\n",
       "      <td>机械革命京东自营官方旗舰店</td>\n",
       "      <td>机械革命(MECHREVO)Z2 72%IPS GTX1060 6G 15.6英寸窄边框吃鸡...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>5b5186f0284df258cc4ef5f2</td>\n",
       "      <td>2.6万+</td>\n",
       "      <td>https://item.jd.com/7341432.html</td>\n",
       "      <td>https://img12.360buyimg.com/n7/jfs/t21904/318/...</td>\n",
       "      <td>6298.00</td>\n",
       "      <td>八代6核i7，1050Ti，防眩光全高清屏，HDMI 2.0 4K 输出</td>\n",
       "      <td>戴尔京东官方自营旗舰店</td>\n",
       "      <td>戴尔DELL游匣G3 15.6英寸游戏笔记本电脑(i7-8750H 8G 128GSSD+1...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>5b5186f0284df258cc4ef5f3</td>\n",
       "      <td>6.8万+</td>\n",
       "      <td>https://item.jd.com/6818156.html</td>\n",
       "      <td>https://img11.360buyimg.com/n7/jfs/t20725/120/...</td>\n",
       "      <td>8999.00</td>\n",
       "      <td>【电竞神器来袭】【GTX 1060 6G独显】72%NTSC色域 超大容量混合硬盘 窄边框全...</td>\n",
       "      <td>小米京东官方自营旗舰店</td>\n",
       "      <td>小米(MI)15.6英寸轻薄窄边框游戏笔记本电脑（i7标压 16G 1T+256G GTX1...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>5b5186f0284df258cc4ef5f4</td>\n",
       "      <td>12万+</td>\n",
       "      <td>https://item.jd.com/5148295.html</td>\n",
       "      <td>https://img10.360buyimg.com/n7/jfs/t7600/145/3...</td>\n",
       "      <td>5399.00</td>\n",
       "      <td>【经典再升级,三边全景7mm微边框】77% 超高屏占比,八代处理器,全新MX150 2G独显...</td>\n",
       "      <td>戴尔京东官方自营旗舰店</td>\n",
       "      <td>戴尔DELL灵越燃7000 II 14.0英寸轻薄窄边框笔记本电脑(i5-8250U 8G ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>5b5186f0284df258cc4ef5f5</td>\n",
       "      <td>8.3万+</td>\n",
       "      <td>https://item.jd.com/4274569.html</td>\n",
       "      <td>https://img14.360buyimg.com/n7/jfs/t21562/169/...</td>\n",
       "      <td>5499.00</td>\n",
       "      <td>【GTX1050Ti】4通道NvME PCIe3.0固态硬盘！》微边框电竞游戏本-暗影4</td>\n",
       "      <td>惠普京东自营官方旗舰店</td>\n",
       "      <td>惠普（HP）暗影精灵III代 15.6英寸游戏笔记本电脑（i5-7300HQ 8G 128G...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>5b5186f0284df258cc4ef5f6</td>\n",
       "      <td>4.7万+</td>\n",
       "      <td>https://item.jd.com/6031973.html</td>\n",
       "      <td>https://img13.360buyimg.com/n7/jfs/t18907/304/...</td>\n",
       "      <td>3699.00</td>\n",
       "      <td>【FHD窄边框】全贴合无边式玻璃覆盖 第七代处理器 128G SSD支持M.2接口 SSD硬...</td>\n",
       "      <td>小米京东官方自营旗舰店</td>\n",
       "      <td>小米(MI) Air 12.5英寸金属超轻薄笔记本电脑(Core M-7Y30 4G 128...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>5b5186f0284df258cc4ef5f7</td>\n",
       "      <td>5.4万+</td>\n",
       "      <td>https://item.jd.com/4331185.html</td>\n",
       "      <td>https://img10.360buyimg.com/n7/jfs/t15184/284/...</td>\n",
       "      <td>11786.00</td>\n",
       "      <td>【新品享6期白条免息】新MacBook Pro，一强再强，八代处理器满血归来！活动期间下单新...</td>\n",
       "      <td>京东Apple产品专营店</td>\n",
       "      <td>Apple MacBook Pro 13.3英寸笔记本电脑 深空灰色（2017款Core i...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>5b5186f1284df258cc4ef5f8</td>\n",
       "      <td>1.7万+</td>\n",
       "      <td>https://item.jd.com/4730611.html</td>\n",
       "      <td>https://img11.360buyimg.com/n7/jfs/t7363/105/5...</td>\n",
       "      <td>8288.00</td>\n",
       "      <td></td>\n",
       "      <td>微软官方自营旗舰店</td>\n",
       "      <td>【黑色键盘套装】微软（Microsoft）新Surface Pro 二合一平板电脑 12.3...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>5b5186f1284df258cc4ef5f9</td>\n",
       "      <td>3.2万+</td>\n",
       "      <td>https://item.jd.com/7061526.html</td>\n",
       "      <td>https://img11.360buyimg.com/n7/jfs/t17428/350/...</td>\n",
       "      <td>4999.00</td>\n",
       "      <td>【暑期特惠】荣耀笔记本，窄边框护眼全高清IPS屏，intel8代CPU+满血版MX150独显...</td>\n",
       "      <td>荣耀京东自营旗舰店</td>\n",
       "      <td>荣耀MagicBook 14英寸轻薄窄边框笔记本电脑（i5-8250U 8G 256G MX...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>5b5186f1284df258cc4ef5fa</td>\n",
       "      <td>7万+</td>\n",
       "      <td>https://item.jd.com/7649695.html</td>\n",
       "      <td>https://img10.360buyimg.com/n7/jfs/t21757/239/...</td>\n",
       "      <td>7299.00</td>\n",
       "      <td>【暗影精灵4】微边框游戏本搭载8代处理器，白条6期免息》微边框电竞游戏本-暗影4</td>\n",
       "      <td>惠普京东自营官方旗舰店</td>\n",
       "      <td>惠普（HP）暗影精灵4代 15.6英寸游戏笔记本电脑（i7-8750H 8G 128G+1T...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>5b5186f1284df258cc4ef5fb</td>\n",
       "      <td>3.6万+</td>\n",
       "      <td>https://item.jd.com/4888355.html</td>\n",
       "      <td>https://img10.360buyimg.com/n7/jfs/t22039/1/57...</td>\n",
       "      <td>4999.00</td>\n",
       "      <td>【高性价商务本】8代4核CPU，搭载MX150！》2018战66新品首发，白条6期免息</td>\n",
       "      <td>惠普京东自营官方旗舰店</td>\n",
       "      <td>惠普（HP）战66 Pro G1 14英寸轻薄笔记本电脑（i5-8250U 8G 256G ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>5b5186f1284df258cc4ef5fc</td>\n",
       "      <td>10万+</td>\n",
       "      <td>https://item.jd.com/7269871.html</td>\n",
       "      <td>https://img11.360buyimg.com/n7/jfs/t18499/89/1...</td>\n",
       "      <td>5399.00</td>\n",
       "      <td>【DDR4内存 PCIE固态硬盘 高色域全高清屏】第八代酷睿i5处理器  全贴合无边式玻璃覆...</td>\n",
       "      <td>小米京东官方自营旗舰店</td>\n",
       "      <td>小米(MI)Air 13.3英寸全金属超轻薄笔记本电脑(i5-8250U 8G 256GSS...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>5b5186f1284df258cc4ef5fd</td>\n",
       "      <td>2万+</td>\n",
       "      <td>https://item.jd.com/5025869.html</td>\n",
       "      <td>https://img14.360buyimg.com/n7/jfs/t7474/343/3...</td>\n",
       "      <td>7699.00</td>\n",
       "      <td>【轻薄窄边框】8代处理器,固态硬盘高端配备,全高清IPS显示屏,全重1.2KG,超长续航无忧...</td>\n",
       "      <td>戴尔京东官方自营旗舰店</td>\n",
       "      <td>戴尔DELL XPS13.3英寸超轻薄窄边框笔记本电脑(i5-8250U 8G 256GSS...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>5b5186f1284df258cc4ef5fe</td>\n",
       "      <td>4.5万+</td>\n",
       "      <td>https://item.jd.com/4311421.html</td>\n",
       "      <td>https://img11.360buyimg.com/n7/jfs/t20428/2/14...</td>\n",
       "      <td>4999.00</td>\n",
       "      <td>【7/20号迎新爆秒24小时！】三面金属机身轻薄本！性能金刚，颜值芭比！灵耀S 2代新品预约...</td>\n",
       "      <td>华硕京东自营官方旗舰店</td>\n",
       "      <td>华硕(ASUS) 灵耀U4000UQ 14英寸合金机身轻薄笔记本电脑(i5-7200U 8G...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>5b5186f1284df258cc4ef5ff</td>\n",
       "      <td>10万+</td>\n",
       "      <td>https://item.jd.com/6274950.html</td>\n",
       "      <td>https://img10.360buyimg.com/n7/jfs/t19834/340/...</td>\n",
       "      <td>5399.00</td>\n",
       "      <td>【DDR4内存 PCIE固态硬盘 高色域全高清屏】第八代酷睿i5处理器  全贴合无边式玻璃覆...</td>\n",
       "      <td>小米京东官方自营旗舰店</td>\n",
       "      <td>小米(MI)Air 13.3英寸全金属超轻薄笔记本电脑(i5-8250U 8G 256GSS...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>5b5186f1284df258cc4ef600</td>\n",
       "      <td>5.4万+</td>\n",
       "      <td>https://item.jd.com/4335099.html</td>\n",
       "      <td>https://img14.360buyimg.com/n7/jfs/t19240/243/...</td>\n",
       "      <td>13698.00</td>\n",
       "      <td>【新品享6期白条免息】新MacBook Pro，一强再强，八代处理器满血归来！活动期间下单新...</td>\n",
       "      <td>京东Apple产品专营店</td>\n",
       "      <td>Apple MacBook Pro 13.3英寸笔记本电脑 银色（2017款Multi-To...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>5b5186f1284df258cc4ef601</td>\n",
       "      <td>4.5万+</td>\n",
       "      <td>https://item.jd.com/6076630.html</td>\n",
       "      <td>https://img10.360buyimg.com/n7/jfs/t15283/100/...</td>\n",
       "      <td>3399.00</td>\n",
       "      <td>【飞匣独显出色展现】2G独显影音娱乐本,键盘防泼溅设计,有效疏导水流,6+续航时间强悍,多彩...</td>\n",
       "      <td>戴尔京东官方自营旗舰店</td>\n",
       "      <td>戴尔DELL灵越飞匣14.0英寸便携笔记本电脑(i5-7200U 4G 500G M430 ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>5b5186f1284df258cc4ef602</td>\n",
       "      <td>2.1万+</td>\n",
       "      <td>https://item.jd.com/7255486.html</td>\n",
       "      <td>https://img11.360buyimg.com/n7/jfs/t21823/174/...</td>\n",
       "      <td>6998.00</td>\n",
       "      <td>【白条3期免息】八代i7+GTX1050Ti电竞旗舰，轻盈纤薄，颜值窄边框，机械键盘机械革命...</td>\n",
       "      <td>机械革命京东自营官方旗舰店</td>\n",
       "      <td>机械革命(MECHREVO)Z2 72%IPS15.6英寸窄边框吃鸡游戏笔记本i7-8750...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>5b5186f1284df258cc4ef603</td>\n",
       "      <td>6.8万+</td>\n",
       "      <td>https://item.jd.com/7028361.html</td>\n",
       "      <td>https://img11.360buyimg.com/n7/jfs/t20332/74/2...</td>\n",
       "      <td>5999.00</td>\n",
       "      <td>【小米重磅游戏本 GTX1050Ti 4G独显 】72%NTSC色域 窄边框全高清屏 冷酷到...</td>\n",
       "      <td>小米京东官方自营旗舰店</td>\n",
       "      <td>小米(MI)15.6英寸轻薄窄边框游戏笔记本电脑（i5标压 8G 1T+128G GTX10...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>5b5186f1284df258cc4ef604</td>\n",
       "      <td>1.3万+</td>\n",
       "      <td>https://item.jd.com/6383824.html</td>\n",
       "      <td>https://img14.360buyimg.com/n7/jfs/t18025/348/...</td>\n",
       "      <td>9999.00</td>\n",
       "      <td>【自成E派 ThinkPad E485新品发售，Plus专享首发价3999元】</td>\n",
       "      <td>ThinkPad京东自营旗舰店</td>\n",
       "      <td>联想ThinkPad X1 Carbon 2018（09CD）14英寸轻薄笔记本电脑（i5-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>5b5186f1284df258cc4ef605</td>\n",
       "      <td>3800+</td>\n",
       "      <td>https://item.jd.com/6023682.html</td>\n",
       "      <td>https://img12.360buyimg.com/n7/jfs/t20920/249/...</td>\n",
       "      <td>6188.00</td>\n",
       "      <td>【大屏微边框性能本】八代i7和双硬盘，满血版MX150 2G独显工作游戏两不误暑你惠玩，白条...</td>\n",
       "      <td>华为京东自营官方旗...</td>\n",
       "      <td>华为(HUAWEI)MateBook D(2018版)15.6英寸轻薄微边框笔记本(i7-8...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>5b5186f1284df258cc4ef606</td>\n",
       "      <td>4200+</td>\n",
       "      <td>https://item.jd.com/6736180.html</td>\n",
       "      <td>https://img10.360buyimg.com/n7/jfs/t17956/336/...</td>\n",
       "      <td>7988.00</td>\n",
       "      <td>【好评如潮】91%屏占比，轻薄与性能兼顾；超长续航，满足一天工作需要；暑你惠玩，白条6期免息...</td>\n",
       "      <td>华为京东自营官方旗...</td>\n",
       "      <td>华为(HUAWEI) MateBook X Pro 13.9英寸超轻薄全面屏笔记本(i5-8...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>5b5186f1284df258cc4ef607</td>\n",
       "      <td>3.8万+</td>\n",
       "      <td>https://item.jd.com/7297627.html</td>\n",
       "      <td>https://img12.360buyimg.com/n7/jfs/t16903/75/2...</td>\n",
       "      <td>7699.00</td>\n",
       "      <td>专属G7金属铭牌，镁铝合金框架，八代标压，1060，指纹、背光键盘、HDMI 2.0、雷电3...</td>\n",
       "      <td>戴尔京东官方自营旗舰店</td>\n",
       "      <td>戴尔DELL游匣G7 15.6英寸游戏笔记本电脑(i5-8300H 8G 128GSSD+1...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>5b5186f1284df258cc4ef608</td>\n",
       "      <td>4.7万+</td>\n",
       "      <td>https://item.jd.com/6043002.html</td>\n",
       "      <td>https://img12.360buyimg.com/n7/jfs/t18181/313/...</td>\n",
       "      <td>4099.00</td>\n",
       "      <td>【FHD窄边框】全贴合无边式玻璃覆盖 第七代处理器 256G SSD支持M.2接口 SSD硬...</td>\n",
       "      <td>小米京东官方自营旗舰店</td>\n",
       "      <td>小米(MI) Air 12.5英寸全金属超轻薄笔记本电脑(Core M-7Y30 4G 25...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>5b5186f1284df258cc4ef609</td>\n",
       "      <td>1.1万+</td>\n",
       "      <td>https://item.jd.com/7158950.html</td>\n",
       "      <td>https://img10.360buyimg.com/n7/jfs/t18364/6/19...</td>\n",
       "      <td>6999.00</td>\n",
       "      <td>【自成E派 ThinkPad E485新品发售，Plus专享首发价3999元】</td>\n",
       "      <td>ThinkPad京东自营旗舰店</td>\n",
       "      <td>联想ThinkPad X280（1PCD）英特尔8代酷睿12.5英寸轻薄笔记本电脑（i5-8...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                         _id comment_num                        detail_url  \\\n",
       "0   5b518331284df258cc4ef5ce        16万+  https://item.jd.com/7418428.html   \n",
       "1   5b51836d284df258cc4ef5cf        21万+  https://item.jd.com/5225346.html   \n",
       "2   5b5183a9284df258cc4ef5d0        16万+  https://item.jd.com/5512841.html   \n",
       "3   5b5183a9284df258cc4ef5d1       9600+  https://item.jd.com/7512626.html   \n",
       "4   5b5183e5284df258cc4ef5d2        21万+  https://item.jd.com/4335139.html   \n",
       "5   5b5183e5284df258cc4ef5d3        16万+  https://item.jd.com/7632577.html   \n",
       "6   5b518421284df258cc4ef5d4       2.6万+  https://item.jd.com/7341442.html   \n",
       "7   5b518421284df258cc4ef5d5         7万+  https://item.jd.com/7435156.html   \n",
       "8   5b51845d284df258cc4ef5d6        12万+  https://item.jd.com/5148309.html   \n",
       "9   5b51845d284df258cc4ef5d7       7.8万+  https://item.jd.com/6072622.html   \n",
       "10  5b518499284df258cc4ef5d8       3.2万+  https://item.jd.com/7271737.html   \n",
       "11  5b5184d5284df258cc4ef5d9        16万+  https://item.jd.com/7886481.html   \n",
       "12  5b5184d5284df258cc4ef5da        10万+  https://item.jd.com/5363894.html   \n",
       "13  5b5184d5284df258cc4ef5db       3.8万+  https://item.jd.com/5352358.html   \n",
       "14  5b518511284df258cc4ef5dc       6.8万+  https://item.jd.com/5029717.html   \n",
       "15  5b518511284df258cc4ef5dd       3.2万+  https://item.jd.com/7275691.html   \n",
       "16  5b518511284df258cc4ef5de       3.5万+  https://item.jd.com/5834183.html   \n",
       "17  5b51854d284df258cc4ef5df        10万+  https://item.jd.com/7102519.html   \n",
       "18  5b51854d284df258cc4ef5e0         7万+  https://item.jd.com/7435200.html   \n",
       "19  5b51858a284df258cc4ef5e1       2.6万+  https://item.jd.com/7555189.html   \n",
       "20  5b51858a284df258cc4ef5e2        12万+  https://item.jd.com/5148299.html   \n",
       "21  5b5185c6284df258cc4ef5e3       4.6万+  https://item.jd.com/1593516.html   \n",
       "22  5b5185c6284df258cc4ef5e4         7万+  https://item.jd.com/7649679.html   \n",
       "23  5b518602284df258cc4ef5e5         7万+  https://item.jd.com/7435168.html   \n",
       "24  5b518602284df258cc4ef5e6       2.1万+  https://item.jd.com/6830412.html   \n",
       "25  5b51863e284df258cc4ef5e7       9200+  https://item.jd.com/3948470.html   \n",
       "26  5b51863e284df258cc4ef5e8        12万+  https://item.jd.com/5148275.html   \n",
       "27  5b51867a284df258cc4ef5e9        10万+  https://item.jd.com/6888588.html   \n",
       "28  5b51867a284df258cc4ef5ea       4.5万+  https://item.jd.com/4315329.html   \n",
       "29  5b51867a284df258cc4ef5eb         7万+  https://item.jd.com/7649609.html   \n",
       "30  5b5186b6284df258cc4ef5ec         1万+  https://item.jd.com/6736174.html   \n",
       "31  5b5186b6284df258cc4ef5ed       1.8万+  https://item.jd.com/5537833.html   \n",
       "32  5b5186b6284df258cc4ef5ee       5.4万+  https://item.jd.com/4331155.html   \n",
       "33  5b5186f0284df258cc4ef5ef        10万+  https://item.jd.com/4752515.html   \n",
       "34  5b5186f0284df258cc4ef5f0       6.8万+  https://item.jd.com/5456134.html   \n",
       "35  5b5186f0284df258cc4ef5f1       2.1万+  https://item.jd.com/7044365.html   \n",
       "36  5b5186f0284df258cc4ef5f2       2.6万+  https://item.jd.com/7341432.html   \n",
       "37  5b5186f0284df258cc4ef5f3       6.8万+  https://item.jd.com/6818156.html   \n",
       "38  5b5186f0284df258cc4ef5f4        12万+  https://item.jd.com/5148295.html   \n",
       "39  5b5186f0284df258cc4ef5f5       8.3万+  https://item.jd.com/4274569.html   \n",
       "40  5b5186f0284df258cc4ef5f6       4.7万+  https://item.jd.com/6031973.html   \n",
       "41  5b5186f0284df258cc4ef5f7       5.4万+  https://item.jd.com/4331185.html   \n",
       "42  5b5186f1284df258cc4ef5f8       1.7万+  https://item.jd.com/4730611.html   \n",
       "43  5b5186f1284df258cc4ef5f9       3.2万+  https://item.jd.com/7061526.html   \n",
       "44  5b5186f1284df258cc4ef5fa         7万+  https://item.jd.com/7649695.html   \n",
       "45  5b5186f1284df258cc4ef5fb       3.6万+  https://item.jd.com/4888355.html   \n",
       "46  5b5186f1284df258cc4ef5fc        10万+  https://item.jd.com/7269871.html   \n",
       "47  5b5186f1284df258cc4ef5fd         2万+  https://item.jd.com/5025869.html   \n",
       "48  5b5186f1284df258cc4ef5fe       4.5万+  https://item.jd.com/4311421.html   \n",
       "49  5b5186f1284df258cc4ef5ff        10万+  https://item.jd.com/6274950.html   \n",
       "50  5b5186f1284df258cc4ef600       5.4万+  https://item.jd.com/4335099.html   \n",
       "51  5b5186f1284df258cc4ef601       4.5万+  https://item.jd.com/6076630.html   \n",
       "52  5b5186f1284df258cc4ef602       2.1万+  https://item.jd.com/7255486.html   \n",
       "53  5b5186f1284df258cc4ef603       6.8万+  https://item.jd.com/7028361.html   \n",
       "54  5b5186f1284df258cc4ef604       1.3万+  https://item.jd.com/6383824.html   \n",
       "55  5b5186f1284df258cc4ef605       3800+  https://item.jd.com/6023682.html   \n",
       "56  5b5186f1284df258cc4ef606       4200+  https://item.jd.com/6736180.html   \n",
       "57  5b5186f1284df258cc4ef607       3.8万+  https://item.jd.com/7297627.html   \n",
       "58  5b5186f1284df258cc4ef608       4.7万+  https://item.jd.com/6043002.html   \n",
       "59  5b5186f1284df258cc4ef609       1.1万+  https://item.jd.com/7158950.html   \n",
       "\n",
       "                                                image     price  \\\n",
       "0   https://img13.360buyimg.com/n7/jfs/t20974/205/...   7299.00   \n",
       "1   https://img11.360buyimg.com/n7/jfs/t14848/365/...   6498.00   \n",
       "2   https://img11.360buyimg.com/n7/jfs/t14947/152/...   5499.00   \n",
       "3   https://img11.360buyimg.com/n7/jfs/t21502/75/4...   3999.00   \n",
       "4   https://img14.360buyimg.com/n7/jfs/t17278/112/...   7898.00   \n",
       "5   https://img12.360buyimg.com/n7/jfs/t21313/152/...   6499.00   \n",
       "6   https://img12.360buyimg.com/n7/jfs/t19939/363/...   5999.00   \n",
       "7   https://img11.360buyimg.com/n7/jfs/t20992/243/...   7699.00   \n",
       "8   https://img14.360buyimg.com/n7/jfs/t11542/236/...   5399.00   \n",
       "9   https://img12.360buyimg.com/n7/jfs/t14920/22/1...   5799.00   \n",
       "10  https://img12.360buyimg.com/n7/jfs/t17458/302/...   4999.00   \n",
       "11  https://img11.360buyimg.com/n7/jfs/t20437/238/...   5799.00   \n",
       "12  https://img14.360buyimg.com/n7/jfs/t20026/165/...   5299.00   \n",
       "13  https://img13.360buyimg.com/n7/jfs/t13369/67/5...   5499.00   \n",
       "14  https://img12.360buyimg.com/n7/jfs/t17083/327/...   5599.00   \n",
       "15  https://img11.360buyimg.com/n7/jfs/t17695/189/...   5699.00   \n",
       "16  https://img13.360buyimg.com/n7/jfs/t16543/130/...   4599.00   \n",
       "17  https://img14.360buyimg.com/n7/jfs/t22198/64/1...   5799.00   \n",
       "18  https://img10.360buyimg.com/n7/jfs/t20098/264/...   6999.00   \n",
       "19  https://img14.360buyimg.com/n7/jfs/t22294/245/...   7999.00   \n",
       "20  https://img14.360buyimg.com/n7/jfs/t11719/257/...   6199.00   \n",
       "21  https://img11.360buyimg.com/n7/jfs/t15601/39/1...  14165.00   \n",
       "22  https://img14.360buyimg.com/n7/jfs/t20014/242/...   6499.00   \n",
       "23  https://img13.360buyimg.com/n7/jfs/t21868/340/...   9999.00   \n",
       "24  https://img12.360buyimg.com/n7/jfs/t20722/13/5...   8299.00   \n",
       "25  https://img10.360buyimg.com/n7/jfs/t16117/315/...   4799.00   \n",
       "26  https://img10.360buyimg.com/n7/jfs/t10453/85/2...   4999.00   \n",
       "27  https://img13.360buyimg.com/n7/jfs/t24586/261/...   5099.00   \n",
       "28  https://img14.360buyimg.com/n7/jfs/t21028/72/1...   4999.00   \n",
       "29  https://img14.360buyimg.com/n7/jfs/t20971/284/...   9299.00   \n",
       "30  https://img14.360buyimg.com/n7/jfs/t24517/167/...   5788.00   \n",
       "31  https://img13.360buyimg.com/n7/jfs/t11191/117/...   6388.00   \n",
       "32  https://img10.360buyimg.com/n7/jfs/t18574/338/...  13698.00   \n",
       "33  https://img10.360buyimg.com/n7/jfs/t19942/328/...   5499.00   \n",
       "34  https://img14.360buyimg.com/n7/jfs/t18268/295/...   6999.00   \n",
       "35  https://img10.360buyimg.com/n7/jfs/t20485/325/...   7997.00   \n",
       "36  https://img12.360buyimg.com/n7/jfs/t21904/318/...   6298.00   \n",
       "37  https://img11.360buyimg.com/n7/jfs/t20725/120/...   8999.00   \n",
       "38  https://img10.360buyimg.com/n7/jfs/t7600/145/3...   5399.00   \n",
       "39  https://img14.360buyimg.com/n7/jfs/t21562/169/...   5499.00   \n",
       "40  https://img13.360buyimg.com/n7/jfs/t18907/304/...   3699.00   \n",
       "41  https://img10.360buyimg.com/n7/jfs/t15184/284/...  11786.00   \n",
       "42  https://img11.360buyimg.com/n7/jfs/t7363/105/5...   8288.00   \n",
       "43  https://img11.360buyimg.com/n7/jfs/t17428/350/...   4999.00   \n",
       "44  https://img10.360buyimg.com/n7/jfs/t21757/239/...   7299.00   \n",
       "45  https://img10.360buyimg.com/n7/jfs/t22039/1/57...   4999.00   \n",
       "46  https://img11.360buyimg.com/n7/jfs/t18499/89/1...   5399.00   \n",
       "47  https://img14.360buyimg.com/n7/jfs/t7474/343/3...   7699.00   \n",
       "48  https://img11.360buyimg.com/n7/jfs/t20428/2/14...   4999.00   \n",
       "49  https://img10.360buyimg.com/n7/jfs/t19834/340/...   5399.00   \n",
       "50  https://img14.360buyimg.com/n7/jfs/t19240/243/...  13698.00   \n",
       "51  https://img10.360buyimg.com/n7/jfs/t15283/100/...   3399.00   \n",
       "52  https://img11.360buyimg.com/n7/jfs/t21823/174/...   6998.00   \n",
       "53  https://img11.360buyimg.com/n7/jfs/t20332/74/2...   5999.00   \n",
       "54  https://img14.360buyimg.com/n7/jfs/t18025/348/...   9999.00   \n",
       "55  https://img12.360buyimg.com/n7/jfs/t20920/249/...   6188.00   \n",
       "56  https://img10.360buyimg.com/n7/jfs/t17956/336/...   7988.00   \n",
       "57  https://img12.360buyimg.com/n7/jfs/t16903/75/2...   7699.00   \n",
       "58  https://img12.360buyimg.com/n7/jfs/t18181/313/...   4099.00   \n",
       "59  https://img10.360buyimg.com/n7/jfs/t18364/6/19...   6999.00   \n",
       "\n",
       "                                          promo_words             shop  \\\n",
       "0   【薄然“新”动，轻薄专场】信仰“Y” Logo灯效，超窄边全面屏，TSI散热，CPU显卡性能...      联想电脑京东自营旗舰店   \n",
       "1   【新品享6期白条免息】新MacBook Pro，一强再强，八代处理器满血归来！活动期间下单新...     京东Apple产品专营店   \n",
       "2   【薄然“新”动，轻薄专场】荣誉勋章，SSD+HDD双硬盘，支持M.2接口固态硬盘，两级可调背...      联想电脑京东自营旗舰店   \n",
       "3   荣耀AMD锐龙5新品，金属微边框轻薄本，薄至15.8mm，护眼全高清IPS屏，57.4Wh大...        荣耀京东自营旗舰店   \n",
       "4   【新品享6期白条免息】新MacBook Pro，一强再强，八代处理器满血归来！活动期间下单新...     京东Apple产品专营店   \n",
       "5   【薄然“新”动，轻薄专场】信仰“Y” Logo灯效，超窄边全面屏，TSI散热，CPU显卡性能...      联想电脑京东自营旗舰店   \n",
       "6                  八代标压，1050Ti，防眩光全高清屏，HDMI 2.0 4K 输出      戴尔京东官方自营旗舰店   \n",
       "7            【暗影精灵4】微边框游戏本搭载8代处理器，白条6期免息》微边框电竞游戏本-暗影4      惠普京东自营官方旗舰店   \n",
       "8   【经典再升级,三边全景7mm微边框】77% 超高屏占比,八代处理器,全新MX150 2G独显...      戴尔京东官方自营旗舰店   \n",
       "9             【自成E派 ThinkPad E485新品发售，Plus专享首发价3999元】  ThinkPad京东自营旗舰店   \n",
       "10  【暑期特惠】荣耀笔记本，窄边框护眼全高清IPS屏，intel8代CPU+满血版MX150独显...        荣耀京东自营旗舰店   \n",
       "11  【薄然“新”动，轻薄专场】信仰“Y” Logo灯效，超窄边全面屏，TSI散热，CPU显卡性能...      联想电脑京东自营旗舰店   \n",
       "12  【薄然“新”动，轻薄专场】三面微边框全高清IPS屏，轻至1.2Kg，采用intel8代CPU...      联想电脑京东自营旗舰店   \n",
       "13    【GTX1050Ti 4G独显】帧率高稳定性强运行更畅快,IPS防眩光显示屏全面还原游戏战场！      戴尔京东官方自营旗舰店   \n",
       "14  【DDR4内存 PCIE固态硬盘 高色域全高清屏】【告别显示器轻装上阵】【15.6英寸MX1...      小米京东官方自营旗舰店   \n",
       "15  【暑期特惠】荣耀笔记本，窄边框护眼全高清IPS屏，intel8代CPU+满血版MX150独显...        荣耀京东自营旗舰店   \n",
       "16  【轻装造梦】300nit ,72%色域IPS屏,机身至薄处15.81mm,8代处理器,背光键...      戴尔京东官方自营旗舰店   \n",
       "17  【薄然“新”动，轻薄专场】极简设计风格，2T+128G双混大存储，三边窄边框80.8%屏占比...      联想电脑京东自营旗舰店   \n",
       "18           【暗影精灵4】微边框游戏本搭载8代处理器，白条6期免息》微边框电竞游戏本-暗影4      惠普京东自营官方旗舰店   \n",
       "19         八代6核i7，1060，制霸全场，畅快”吃鸡”，背光键盘、HDMI 2.0， 雷电3      戴尔京东官方自营旗舰店   \n",
       "20  【经典再升级,三边全景7mm微边框】77% 超高屏占比,八代处理器,全新MX150 2G独显...      戴尔京东官方自营旗舰店   \n",
       "21  【新品享6期白条免息】新MacBook Pro，一强再强，八代处理器满血归来！活动期间下单新...     京东Apple产品专营店   \n",
       "22           【暗影精灵4】微边框游戏本搭载8代处理器，白条6期免息》微边框电竞游戏本-暗影4      惠普京东自营官方旗舰店   \n",
       "23           【暗影精灵4】微边框游戏本搭载8代处理器，白条6期免息》微边框电竞游戏本-暗影4      惠普京东自营官方旗舰店   \n",
       "24  【白条3期免息】144Hz电竞屏，八代i7+GTX1060电竞旗舰，光轴机械键盘机械革命笔记...    机械革命京东自营官方旗舰店   \n",
       "25            【自成E派 ThinkPad E485新品发售，Plus专享首发价3999元】  ThinkPad京东自营旗舰店   \n",
       "26  【经典再升级,三边全景7mm微边框】77% 超高屏占比,八代处理器,SSD固态硬盘快速响应,...      戴尔京东官方自营旗舰店   \n",
       "27  【薄然“新”动，轻薄专场】极简设计风格，2T+128G双混大存储，三边窄边框80.8%屏占比...      联想电脑京东自营旗舰店   \n",
       "28  【7/20号迎新爆秒24小时！】三面金属机身轻薄本！性能金刚，颜值芭比！灵耀S 2代新品预约...      华硕京东自营官方旗舰店   \n",
       "29           【暗影精灵4】微边框游戏本搭载8代处理器，白条6期免息》微边框电竞游戏本-暗影4      惠普京东自营官方旗舰店   \n",
       "30  【7/20号迎新爆秒24小时！】新8代CPU/PCIE硬盘，比它们快一些的高速硬盘！灵耀S ...      华硕京东自营官方旗舰店   \n",
       "31                                                           微软官方自营旗舰店   \n",
       "32  【新品享6期白条免息】新MacBook Pro，一强再强，八代处理器满血归来！活动期间下单新...     京东Apple产品专营店   \n",
       "33  【薄然“新”动，轻薄专场】三面微边框全高清IPS屏，轻至1.2Kg，采用intel8代CPU...      联想电脑京东自营旗舰店   \n",
       "34  【DDR4内存 PCIE固态硬盘 高色域全高清屏】【皇冠级性能本】 第八代酷睿I7处理器 专...      小米京东官方自营旗舰店   \n",
       "35  【白条3期免息】八代i7+GTX1060电竞旗舰，轻盈纤薄，颜值窄边框，光轴机械键盘机械革命...    机械革命京东自营官方旗舰店   \n",
       "36               八代6核i7，1050Ti，防眩光全高清屏，HDMI 2.0 4K 输出      戴尔京东官方自营旗舰店   \n",
       "37  【电竞神器来袭】【GTX 1060 6G独显】72%NTSC色域 超大容量混合硬盘 窄边框全...      小米京东官方自营旗舰店   \n",
       "38  【经典再升级,三边全景7mm微边框】77% 超高屏占比,八代处理器,全新MX150 2G独显...      戴尔京东官方自营旗舰店   \n",
       "39       【GTX1050Ti】4通道NvME PCIe3.0固态硬盘！》微边框电竞游戏本-暗影4      惠普京东自营官方旗舰店   \n",
       "40  【FHD窄边框】全贴合无边式玻璃覆盖 第七代处理器 128G SSD支持M.2接口 SSD硬...      小米京东官方自营旗舰店   \n",
       "41  【新品享6期白条免息】新MacBook Pro，一强再强，八代处理器满血归来！活动期间下单新...     京东Apple产品专营店   \n",
       "42                                                           微软官方自营旗舰店   \n",
       "43  【暑期特惠】荣耀笔记本，窄边框护眼全高清IPS屏，intel8代CPU+满血版MX150独显...        荣耀京东自营旗舰店   \n",
       "44           【暗影精灵4】微边框游戏本搭载8代处理器，白条6期免息》微边框电竞游戏本-暗影4      惠普京东自营官方旗舰店   \n",
       "45        【高性价商务本】8代4核CPU，搭载MX150！》2018战66新品首发，白条6期免息      惠普京东自营官方旗舰店   \n",
       "46  【DDR4内存 PCIE固态硬盘 高色域全高清屏】第八代酷睿i5处理器  全贴合无边式玻璃覆...      小米京东官方自营旗舰店   \n",
       "47  【轻薄窄边框】8代处理器,固态硬盘高端配备,全高清IPS显示屏,全重1.2KG,超长续航无忧...      戴尔京东官方自营旗舰店   \n",
       "48  【7/20号迎新爆秒24小时！】三面金属机身轻薄本！性能金刚，颜值芭比！灵耀S 2代新品预约...      华硕京东自营官方旗舰店   \n",
       "49  【DDR4内存 PCIE固态硬盘 高色域全高清屏】第八代酷睿i5处理器  全贴合无边式玻璃覆...      小米京东官方自营旗舰店   \n",
       "50  【新品享6期白条免息】新MacBook Pro，一强再强，八代处理器满血归来！活动期间下单新...     京东Apple产品专营店   \n",
       "51  【飞匣独显出色展现】2G独显影音娱乐本,键盘防泼溅设计,有效疏导水流,6+续航时间强悍,多彩...      戴尔京东官方自营旗舰店   \n",
       "52  【白条3期免息】八代i7+GTX1050Ti电竞旗舰，轻盈纤薄，颜值窄边框，机械键盘机械革命...    机械革命京东自营官方旗舰店   \n",
       "53  【小米重磅游戏本 GTX1050Ti 4G独显 】72%NTSC色域 窄边框全高清屏 冷酷到...      小米京东官方自营旗舰店   \n",
       "54            【自成E派 ThinkPad E485新品发售，Plus专享首发价3999元】  ThinkPad京东自营旗舰店   \n",
       "55  【大屏微边框性能本】八代i7和双硬盘，满血版MX150 2G独显工作游戏两不误暑你惠玩，白条...     华为京东自营官方旗...   \n",
       "56  【好评如潮】91%屏占比，轻薄与性能兼顾；超长续航，满足一天工作需要；暑你惠玩，白条6期免息...     华为京东自营官方旗...   \n",
       "57  专属G7金属铭牌，镁铝合金框架，八代标压，1060，指纹、背光键盘、HDMI 2.0、雷电3...      戴尔京东官方自营旗舰店   \n",
       "58  【FHD窄边框】全贴合无边式玻璃覆盖 第七代处理器 256G SSD支持M.2接口 SSD硬...      小米京东官方自营旗舰店   \n",
       "59            【自成E派 ThinkPad E485新品发售，Plus专享首发价3999元】  ThinkPad京东自营旗舰店   \n",
       "\n",
       "                                                title  \n",
       "0   联想(Lenovo)拯救者Y7000 15.6英寸游戏笔记本电脑(英特尔八代酷睿i7-875...  \n",
       "1   Apple MacBook Air 13.3英寸笔记本电脑 银色(2017款Core i5 ...  \n",
       "2   联想(Lenovo)拯救者R720 15.6英寸大屏游戏笔记本电脑(i5-7300HQ 8G...  \n",
       "3   荣耀MagicBook 14英寸轻薄窄边框笔记本电脑（AMD锐龙5 8G 256G FHD ...  \n",
       "4   Apple MacBook Air 13.3英寸笔记本电脑 银色(2017款Core i5 ...  \n",
       "5   联想(Lenovo)拯救者Y7000 15.6英寸游戏笔记本电脑(英特尔八代酷睿i5-830...  \n",
       "6   戴尔DELL游匣G3 15.6英寸游戏笔记本电脑(i5-8300H 8G 128GSSD+1...  \n",
       "7   惠普（HP）暗影精灵4代 15.6英寸游戏笔记本电脑（i5-8300H 8G 128G+1T...  \n",
       "8   戴尔DELL灵越燃7000 II 14.0英寸轻薄窄边框笔记本电脑(i5-8250U 8G ...  \n",
       "9   联想ThinkPad 翼480（0VCD）英特尔8代酷睿14英寸轻薄窄边框笔记本电脑（i5-...  \n",
       "10  荣耀MagicBook 14英寸轻薄窄边框笔记本电脑（i5-8250U 8G 256G MX...  \n",
       "11  联想(Lenovo)拯救者Y7000 15.6英寸游戏笔记本电脑(英特尔八代酷睿i5-830...  \n",
       "12  联想(Lenovo)小新潮7000 13.3英寸超轻薄窄边框笔记本电脑(i5-8250U 8...  \n",
       "13  戴尔DELL灵越游匣Master15.6英寸游戏笔记本电脑(i5-7300HQ 8G 128...  \n",
       "14  小米(MI)Pro 15.6英寸金属轻薄笔记本(i5-8250U 8G 256GSSD MX...  \n",
       "15  荣耀MagicBook 14英寸轻薄窄边框笔记本电脑（i7-8550U 8G 256G MX...  \n",
       "16  戴尔DELL成就5000不凡银13.3英寸商务办公超轻薄便携笔记本电脑(i5-8250U 8...  \n",
       "17  联想(Lenovo)小新潮7000 2018款 14英寸轻薄笔记本电脑(英特尔八代酷睿I7-...  \n",
       "18  惠普（HP）暗影精灵4代 15.6英寸游戏笔记本电脑（i5-8300H 8G 128G+1T...  \n",
       "19  戴尔DELL游匣G3 15.6英寸游戏笔记本电脑(i7-8750H 8G 128GSSD+1...  \n",
       "20  戴尔DELL灵越燃7000 II 14.0英寸轻薄窄边框笔记本电脑(i7-8550U 8G ...  \n",
       "21  Apple MacBook Pro 15.4英寸笔记本电脑 银色(Core i7 处理器/1...  \n",
       "22  惠普（HP）暗影精灵4代 15.6英寸游戏笔记本电脑（i5-8300H 8G 128G+1T...  \n",
       "23  惠普（HP）暗影精灵4代 15.6英寸游戏笔记本电脑（i7-8750H 16G 128G+1...  \n",
       "24  机械革命(MECHREVO)X8Ti 8代酷睿i7-8750H GTX1060 144Hz7...  \n",
       "25  联想ThinkPad E470（1RCD）英特尔7代酷睿14英寸笔记本电脑（i5-7200U...  \n",
       "26  戴尔DELL灵越燃7000 II 14.0英寸轻薄窄边框笔记本电脑(i5-8250U 8G ...  \n",
       "27  联想(Lenovo)小新潮7000 14英寸轻薄笔记本电脑(英特尔八代酷睿I5-8250U ...  \n",
       "28  华硕(ASUS) 灵耀U4000UQ 14英寸合金机身轻薄笔记本电脑(i5-7200U 8G...  \n",
       "29  惠普（HP）暗影精灵4代 15.6英寸游戏笔记本电脑（i7-8750H 8G 128G+1T...  \n",
       "30  华硕(ASUS) 飞行堡垒五代FX80 15.6英寸游戏笔记本电脑(i5-8300H 8G ...  \n",
       "31  微软（Microsoft）新Surface Pro 二合一平板电脑 12.3英寸（Intel...  \n",
       "32  Apple MacBook Pro 13.3英寸笔记本电脑 深空灰色（2017款Multi-...  \n",
       "33  联想(Lenovo)小新潮7000 13.3英寸超轻薄窄边框笔记本电脑(i7-8550U 8...  \n",
       "34  小米(MI)Pro 15.6英寸金属轻薄笔记本(i7-8550U 16G 256GSSD M...  \n",
       "35  机械革命(MECHREVO)Z2 72%IPS GTX1060 6G 15.6英寸窄边框吃鸡...  \n",
       "36  戴尔DELL游匣G3 15.6英寸游戏笔记本电脑(i7-8750H 8G 128GSSD+1...  \n",
       "37  小米(MI)15.6英寸轻薄窄边框游戏笔记本电脑（i7标压 16G 1T+256G GTX1...  \n",
       "38  戴尔DELL灵越燃7000 II 14.0英寸轻薄窄边框笔记本电脑(i5-8250U 8G ...  \n",
       "39  惠普（HP）暗影精灵III代 15.6英寸游戏笔记本电脑（i5-7300HQ 8G 128G...  \n",
       "40  小米(MI) Air 12.5英寸金属超轻薄笔记本电脑(Core M-7Y30 4G 128...  \n",
       "41  Apple MacBook Pro 13.3英寸笔记本电脑 深空灰色（2017款Core i...  \n",
       "42  【黑色键盘套装】微软（Microsoft）新Surface Pro 二合一平板电脑 12.3...  \n",
       "43  荣耀MagicBook 14英寸轻薄窄边框笔记本电脑（i5-8250U 8G 256G MX...  \n",
       "44  惠普（HP）暗影精灵4代 15.6英寸游戏笔记本电脑（i7-8750H 8G 128G+1T...  \n",
       "45  惠普（HP）战66 Pro G1 14英寸轻薄笔记本电脑（i5-8250U 8G 256G ...  \n",
       "46  小米(MI)Air 13.3英寸全金属超轻薄笔记本电脑(i5-8250U 8G 256GSS...  \n",
       "47  戴尔DELL XPS13.3英寸超轻薄窄边框笔记本电脑(i5-8250U 8G 256GSS...  \n",
       "48  华硕(ASUS) 灵耀U4000UQ 14英寸合金机身轻薄笔记本电脑(i5-7200U 8G...  \n",
       "49  小米(MI)Air 13.3英寸全金属超轻薄笔记本电脑(i5-8250U 8G 256GSS...  \n",
       "50  Apple MacBook Pro 13.3英寸笔记本电脑 银色（2017款Multi-To...  \n",
       "51  戴尔DELL灵越飞匣14.0英寸便携笔记本电脑(i5-7200U 4G 500G M430 ...  \n",
       "52  机械革命(MECHREVO)Z2 72%IPS15.6英寸窄边框吃鸡游戏笔记本i7-8750...  \n",
       "53  小米(MI)15.6英寸轻薄窄边框游戏笔记本电脑（i5标压 8G 1T+128G GTX10...  \n",
       "54  联想ThinkPad X1 Carbon 2018（09CD）14英寸轻薄笔记本电脑（i5-...  \n",
       "55  华为(HUAWEI)MateBook D(2018版)15.6英寸轻薄微边框笔记本(i7-8...  \n",
       "56  华为(HUAWEI) MateBook X Pro 13.9英寸超轻薄全面屏笔记本(i5-8...  \n",
       "57  戴尔DELL游匣G7 15.6英寸游戏笔记本电脑(i5-8300H 8G 128GSSD+1...  \n",
       "58  小米(MI) Air 12.5英寸全金属超轻薄笔记本电脑(Core M-7Y30 4G 25...  \n",
       "59  联想ThinkPad X280（1PCD）英特尔8代酷睿12.5英寸轻薄笔记本电脑（i5-8...  "
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "db = 'jd'\n",
    "table = 'products'\n",
    "cursor = client[db][table].find()\n",
    "data = pd.DataFrame(list(cursor))\n",
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
